Create a report to show specific Security Update KB

[bleeloy]

I'm trying to write a report to look for a particular Microsoft KB installed during the last round of patch Tuesday updates. I can see the update when looking at an asset under the History tab, but I cannot find the correct table(s) to pull the information from for the report.

[Susan_A · Accepted solution]

All history is stored in database tables ending in "Hist". Update history specifically is stored in the tblQuickFixEngineeringHist table. To create a report:

• Open the report builder under Reports\Create New Report.
  
• Double-click on tblQuickFixEngineeringHist and tblQuickFixEngineeringUni to add the tables to your report.
  
• In the upper section of the report builder, drag the QFEID field of one of the QuickFix tables over to the QFEID field of the other table to create a link.
  
• In the upper section of the report builder, tick the Action field in tblQuickFixEngineeringHist and the HotFixID field in tblQuickFixEngineeringUni.
  
• Give the report a title, run it and filter it further within the report results. You can submit the KB number in the HotFixID box and the action in the Action box. ("1" means the patch was added, "2" means it was removed.)