Patch Report

[Srikanth08]

Hi,

i need to have one report like particular windows patch installed in which machines missed in which machines like that

[Hemoco]

Please check one or more of these systems. If a system is included in the report, that means it doesn't have the specified hotfix installed. Note that you must replace YourFix with your hotfix ID.

[Srikanth08]

Hi,

When i run this report it is showing 3000+ Systems..that means in that many systems it is not updated..i dont think so..

[Hemoco]

A sample report was posted here: http://lansweeper.com/forum/yaf_postst7317_Report-for-Missing-Hotfix.aspx

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