rriverososa wrote:
I know there are a few reports about Windows Updates around here, but I am here because I need something in particular.
I wish to have a report that would display all of my windows servers in the report and that it would tell me which servers have not been updated ( havn't installed updates ) within the past 2 weeks. I currently have my servers to scan everyday for updates, but the installations are manual.
Perhaps we can also filter them and only show those results.
If anybody is kind enough to script this I would appreciate it very much.
Try this one:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tsysOS.Image As icon,
tblAssetCustom.LastPatched
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.LastPatched < GetDate() - 14 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssetCustom.LastPatched Desc
