cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mc_
Engaged Sweeper
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?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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