→ 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: 
lessthansubtle
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now