cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RJGeek
Engaged Sweeper
Hi,
I'd like to create a report which ONLY lists computers which have a Windows Server OS installed (2003, 2008, 2008 R2, 2012, 2012 R2, 2016 etc), the server name, IP address and the last windows update patch\install date.

The order below would be great

Server Name
Server OS installed
IP Address
Last Date Windows patch was installed


Thanks for your help in advance. RJ
1 REPLY 1
jmcbride
Engaged Sweeper
Try this; keep in mind that the Last Patched field has to be manually filled in. https://www.lansweeper.com/Forum/yaf_postst12311_Fill-field--Last-Patched--automatically.aspx#post44...

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.OScode As Build,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblAssetCustom.LastPatched
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblComputersystem.Domainrole >= 2
Order By tblAssets.AssetName