Report for Missing Hotfix

[atkinsjd]

I am looking for a list of machines missing a particular quickfix. This report I found in the forum looks like it will do the job. Is there a 5.0 version available?


Select Top (1000000) tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
Web40OSName.OSname, Web40OSName.Compimage As icon
From tblComputers Left Outer Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where
tblComputers.Computername Not In (Select tblQuickFixEngineering.Computername
From tblQuickFixEngineering
Where tblQuickFixEngineering.HotFixID = 'KB2667402') And
tblOperatingsystem.Version Like '6.1%'
Order By tblComputers.ComputerUnique

[Hemoco]

A sample 5.0 report can be seen below. Replace YourFix with the hotfix ID.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblQuickFixEngineering.AssetID
From tblQuickFixEngineering Inner Join tblQuickFixEngineeringUni
On tblQuickFixEngineeringUni.QFEID = tblQuickFixEngineering.QFEID
Where tblQuickFixEngineeringUni.HotFixID = 'YourFix') And
tsysAssetTypes.AssetTypename = 'windows' And tblAssetCustom.State = 1