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