Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Enzo
Engaged Sweeper

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.

1 REPLY 1
Mister_Nobody
Honored Sweeper III

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

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now