Report with last patch date, server OS, server name and IP

[RJGeek]

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

[jmcbride]

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