11-21-2012 05:37 PM
Solved! Go to Solution.
11-21-2012 06:15 PM
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.LastknownIP As IP, tblComputers.Username, tblComputers.Userdomain, tblComputersystem.Manufacturer, tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber As AssetTag, web40ProcessorCapacity.CPU, web40CorrectMemory.Memory, Web40OSName.OSname As OS, tblOperatingsystem.Caption As FullOSName, Web40OSName.SP, Web40OSName.OScode From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Order By tblComputers.ComputerUnique
11-21-2012 06:15 PM
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.LastknownIP As IP, tblComputers.Username, tblComputers.Userdomain, tblComputersystem.Manufacturer, tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber As AssetTag, web40ProcessorCapacity.CPU, web40CorrectMemory.Memory, Web40OSName.OSname As OS, tblOperatingsystem.Caption As FullOSName, Web40OSName.SP, Web40OSName.OScode From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now