Inventory help

[gamero]

Hello All,

I am trying to get a server list from are network. I want the list to include Asset name, IP address, OS Type (Including Linux, RedHAT).. Can someone help me with this?

Thanks...

[Susan_A · Accepted solution]

There is no specific database field that identifies Linux machines as servers. Such a field only exists for Windows computers. The sample report below lists Windows servers and all Linux assets. Instructions for adding this report to your installation can be found here. If you are interested in building or modifying reports, we would 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,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblOperatingsystem.Caption As WindowsOS,
  tblLinuxSystem.OSRelease As LinuxOS
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where (tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1) Or
  (tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1)
Order By tblAssets.IPNumeric