→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cerede2000
Engaged Sweeper
Hi,

I want find computer has specific KB installed.

How make this ?

Thanks 🙂
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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.

View solution in original post

3 REPLIES 3
Susan_A
Lansweeper Alumni
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
Engaged Sweeper
Thanks 🙂

But why LanSweeper not include KB fixes list ?
Susan_A
Lansweeper Alumni
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.