Find comptuer has Microsoft KB

[cerede2000]

Hi,

I want find computer has specific KB installed.

How make this ?

Thanks 🙂

[Susan_A]

Lansweeper cannot tell you which fixes are missing from a machine, if this is what you're referring to. It only scans hotfixes that are already installed. This information is pulled from the Win32_QuickFixEngineering WMI (Windows Management Instrumentation) class. More info on this class can be found here.

You can list installed hotfixes by following the instructions in our previous post. This information is also listed in the Config/Windows/Quickfix section of individual computer webpages.

[cerede2000]

Thanks 🙂

But why LanSweeper not include KB fixes list ?

[Susan_A · Accepted solution]

Do the following:

• Open the report builder under Reports\Create New Report.
  
• Double-click on tblQuickFixEngineering and tblQuickFixEngineeringUni in the table list on the right to add the tables to your report.
  
• In the visual representation of the report in the upper section of the report builder, tick the HotFixID field in tblQuickFixEngineeringUni.
  
• Give the report a title and hit Save & Run.
  
• Filter the HotFixID column within the report results.

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

• Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  
• Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.