→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gamero
Engaged Sweeper
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...
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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