Only Windows Servers?

[sailor]

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, etc). All I really need to have is the asset name, and the OS version installed. The pre-defined asset lists always seem to include some desktop OS in them.

[RCorbeil]

Use the View Database Documentation link at the top of report builder.

The Windows server/workstation classification is found in tblComputersystem.Domainrole. If you want to see the descriptions of the roles, link in tbldomainroles. 0 and 1 are two classes of workstation. 2 through 5 are classes of server.

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblComputersystem.Domainrole,
  tbldomainroles.Domainrolename,  -- optional
  tsysOS.OSname,                  -- optional
  tblOperatingsystem.Caption      -- optional
FROM
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
  INNER JOIN tblComputersystem ON tblAssets.AssetID = tblComputersystem.AssetID
  -- Optional for role description
  INNER JOIN tbldomainroles ON tbldomainroles.Domainrole = tblComputersystem.Domainrole
  -- Optional for short OS name
  INNER JOIN tsysOS ON tblAssets.OScode = tsysOS.OScode
  -- Optional for long OS name
  	tblOperatingsystem ON tblAssets.AssetID = tblOperatingsystem.AssetID
WHERE
  tblComputersystem.Domainrole > 1 -- only Windows servers
  AND tblAssetCustom.State = 1