→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
d_i_saunders
Engaged Sweeper III
Any one created a report to show the patching status of servers and workstations taking MS12-020

Thought I would ask first.


dave
2 REPLIES 2
cbtg2006
Engaged Sweeper
This is what I use for this hotfix check:
-------------------------------------------

Select DISTINCT tblcomputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain
From tblComputers
Inner Join
tblQuickFixEngineering On tblComputers.Computername =
tblQuickFixEngineering.Computername

Where tblComputers.Computername
Not In(Select Computername From tblQuickFixEngineering Where tblQuickFixEngineering.HotFixID = 'KB2621440' or tblQuickFixEngineering.HotFixID = 'KB2667402')

Order By tblComputers.ComputerUnique
Hemoco
Lansweeper Alumni
Installed updates can be found in tblQuickFixEngineering within the Lansweeper report builder. An example report can be seen below. Replace “YourID” with the hotfix ID you would like to report on.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblQuickFixEngineering.Description,
tblQuickFixEngineering.FixComments, tblQuickFixEngineering.HotFixID,
tblQuickFixEngineering.InstalledOn
From tblComputers Inner Join
tblQuickFixEngineering On tblComputers.Computername =
tblQuickFixEngineering.Computername
Where tblQuickFixEngineering.HotFixID = 'YourID'
Order By tblComputers.ComputerUnique, tblQuickFixEngineering.HotFixID


To use the specified report, do the following:
- Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
- Copy the SQL code provided and paste it in the bottom of the newly created report, replacing the default SQL code.
- Click somewhere near tblComputers so the new code applies.
- Give the report a “View name” and a “Report name” and hit the “Save” button.
- Double-click on the report in the report list to see its results and export options.