→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
This report will list all installed Windows hotfixes on a reference computer (i.e. lab computer) called "Reference" in the example below. Next to each hotfix a list of workstations will be displayed not having it installed.

This report takes longer time to run, it is recommended to have Lansweeper installed on SQL server Express or higher edition.


Select Top 1000000 tblQuickFixEngineeringUni.HotFixID,
tblQuickfixengineeringUni.Description,
tNotInstalled.AssetID,
tNotInstalled.AssetName
From tblQuickFixEngineering
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineering.QFEID =
tblQuickFixEngineeringUni.QFEID
Inner Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
Left Join (Select tblQuickFixEngineeringUni.QFEID,
tblAssets.AssetID,
tblAssets.AssetName
From tblQuickFixEngineeringUni,
tblAssets
Inner Join tblComputersystem
On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
Not Exists(Select tblQuickFixEngineering.QFEID,
tblQuickFixEngineering.AssetID From tblQuickFixEngineering
Where tblQuickFixEngineering.QFEID = tblQuickFixEngineeringUni.QFEID And
tblQuickFixEngineering.AssetID = tblAssets.AssetID)) tNotInstalled
On tNotInstalled.QFEID = tblQuickFixEngineering.QFEID
Where tblAssets.AssetName = 'Reference'
Order By tblQuickFixEngineeringUni.HotFixID,
tNotInstalled.AssetName
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

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

Try Now