Jetzt Ausprobieren

All Servers Types

Hardware Operating System

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 by type

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

Show

Hide