→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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.