Report - KB report details for the month of February

[Enzo]

I need to create a report that shows the details of the KBs that were installed in the Windows update in the month of February.

How can this report be made? Does anyone have an idea? The idea is to make a report for each KB, similar to the one made in WSUS?

Thank you

Enzo.

[Knytmar3 · Accepted solution]

Hi Enzo,

Using Mister_Nobody's table and adding a AND query then including Year field such as below:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblQuickFixEngineering.InstalledOn,
  tblQuickFixEngineeringUni.HotFixID
From tblassets
  Inner Join tblQuickFixEngineering On
      tblassets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineering.QFEID =
      tblQuickFixEngineeringUni.QFEID
Where Month(tblQuickFixEngineering.InstalledOn) = 2 AND
  Year(tblQuickFixEngineering.InstalledOn) = 2025
Order By tblassets.AssetName

Then exporting the report to Excel, you can use Filtering on the HotFixID eg, Selecting "KB5051974"
And you will then get the list of Hosts (AssetName) where said KB was installed for the month of Feb 2025.

Alternatively apply the filter on the AssetName column to view KB's installed on said Host for the month of February.

@Mister_Nobody  thank you for your Query and input 🙂 

[Mister_Nobody]

Very strange request, but try this report:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblQuickFixEngineering.InstalledOn,
  tblQuickFixEngineeringUni.HotFixID
From tblassets
  Inner Join tblQuickFixEngineering On
      tblassets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineering.QFEID =
      tblQuickFixEngineeringUni.QFEID
Where Month(tblQuickFixEngineering.InstalledOn) = 2
Order By tblassets.AssetName

[Enzo]

Mister_Nobody.

Thank you for answering my questions. I think I have not explained myself well. The requirement I have is to generate a report for each of the KBs that are installed in the month of February. For example: KB5051974. For this KB I need to know which workstations have this KB installed.

Even though the report you sent me shows it, I need to know for each of the KBs which computer or server has it.

Thank you for your support and collaboration.

Thank you.

Enzo.

[Knytmar3 · Accepted solution]

Hi Enzo,

Using Mister_Nobody's table and adding a AND query then including Year field such as below:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblQuickFixEngineering.InstalledOn,
  tblQuickFixEngineeringUni.HotFixID
From tblassets
  Inner Join tblQuickFixEngineering On
      tblassets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineering.QFEID =
      tblQuickFixEngineeringUni.QFEID
Where Month(tblQuickFixEngineering.InstalledOn) = 2 AND
  Year(tblQuickFixEngineering.InstalledOn) = 2025
Order By tblassets.AssetName

Then exporting the report to Excel, you can use Filtering on the HotFixID eg, Selecting "KB5051974"
And you will then get the list of Hosts (AssetName) where said KB was installed for the month of Feb 2025.

Alternatively apply the filter on the AssetName column to view KB's installed on said Host for the month of February.

@Mister_Nobody  thank you for your Query and input 🙂 

[Enzo · Accepted solution]

Thank you very much for the solution @Mister_Nobody

Thank you
Enzo