Reference Windows Hotfix list

[Daniel_B]

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