Need help with Computer and Server report

[mbuzard]

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

[Hemoco · Accepted solution]

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.