List All Server Types in Your Network
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