Report for really all server

[Nukular]

I try to edit an report which should show me all server but its only showing Windows server. I know its because "tblComputersystem.Domainrole > 1" but when i remove this i simply see all Windows Computer.

How do i get an report with really all server, Windows AND Linux?

I am workin with this report:

Select Top 1000000 tblAssets.AssetName,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.Memory,
tblAssets.Processor
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.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

[Susan_A · Accepted solution]

There is no specific database field that indicates whether or not a Linux machine is a server. To list Windows servers and all Linux assets, use the report below. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tblAssets.IPAddress,
  Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease) As OS,
  tblAssets.Memory,
  tblAssets.Processor,
  tsysAssetTypes.AssetTypeIcon10 As icon
From tblComputersystem
  Right Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where (tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1) Or
  (tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName