reporting for KB updates

[Starbug1]

Hi, i am using the latest version, cannot seem to find a pre-build in report that lets me search to see if a specific KB is installed across my server estate, is there a better way of doing this with something built in, or does it need to be a custom?

[Mister_Nobody]

https://your_server_name/Report/report.aspx?det=changes&page=QuickFixEngineering

[DavidPK]

Below you can find a sample report that will list all assets which have(sample KB4880970) installed. We used a sample KB and this can be replaced in the query for the one you are looking for. 
 

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
• Checking out our report library: https://www.lansweeper.com/report/

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID In (Select Top 1000000 tblQuickFixEngineering.AssetID
      From tblQuickFixEngineering Inner Join tblQuickFixEngineeringUni
          On tblQuickFixEngineeringUni.QFEID = tblQuickFixEngineering.QFEID
      Where tblQuickFixEngineeringUni.HotFixID Like '%KB4880970%') And
  tblAssetCustom.State = 1 And tblAssets.Uptime Is Not Null
Order By tblAssets.Domain,
  tblAssets.AssetName