→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tdecenso
Engaged Sweeper
Is there a way in Lansweeper 4.2 to create a report for specific KBs. If not is there a way to enable KB scanning on the local machine.

Thanks

Tim
2 REPLIES 2
tdecenso
Engaged Sweeper
Thank You X 10000000
Hemoco
Lansweeper Alumni
Hotfix info can be found in tblQuickFixEngineering within the Lansweeper report builder. A basic report is shown below. Replace "YourKB" with the hotfix you're after.

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