Report on Server IP addresses

[lessthansubtle]

Is there a report for Lansweeper where I can have all the servers on my network listed by their computer name and ip address only?

Thanks

[Daniel_B · Accepted solution]

Windows servers can be recognized by the field tblComputersystem.Domainrole. The following report lists all Windows servers in your network. Alternatively, use the built-in report Server: All Servers which is available here as well.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress
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
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1