All Servers Types

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,
  tsysOS.Image As icon,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) As OS,
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

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting