→ 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: 
mbuzard
Engaged Sweeper
I have the following report, but is does not include Linux devices. How do I add those devices?

Select Top 1000000 tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation, tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, Web40OSName.Compimage As icon, tblCompCustom.Custom1 From tblComputers Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Left Join tblCompCustom On tblCompCustom.Computername = tblComputers.Computername Where tblComputers.LastknownIP <> '' Order By dbo.tblComputers.IPNumeric
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Linux machines are currently considered "devices" in Lansweeper. Device and computer info cannot easily be integrated into a single report. One of our future updates will merge computers and devices into a single "asset" category.

For now you will have to create a separate report using tblCustDevices and web40AllIPLocationsDev for the IP location.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Linux machines are currently considered "devices" in Lansweeper. Device and computer info cannot easily be integrated into a single report. One of our future updates will merge computers and devices into a single "asset" category.

For now you will have to create a separate report using tblCustDevices and web40AllIPLocationsDev for the IP location.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now