Discover all servers in your network with their specific server type. This audit will show all the servers scanned in your network along with the type of server operating system they have. With the filtering and sorting options in the report, you can easily filter for specific server types. Additionally, you can use the sorting options to view which operating systems were most recently changed.
All Servers Types Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) As OS,
tblOperatingsystem.Lastchanged
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName
