Number of pending Windows updates

[mc_]

Is there a way to create a report that shows the computer name and next to it the number of pending Windows updates waiting to be installed?

[Daniel_B · Accepted solution]

Lansweeper only scans Windows hotfixes which already have been installed. You might consider scanning a reference computer which has all updates installed and afterwards run the following report in order to see if a specific target computer has the same updates installed or not (missing hotfixes are listed in the report):

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.AssetName Like 'targetComputerName' And 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 = 'refereceComputerName'
Order By tblQuickFixEngineeringUni.HotFixID,
  tNotInstalled.AssetName