→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎10-11-2010 07:16 PM
Solved! Go to Solution.
‎10-11-2010 07:59 PM
Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole = '3' Order By dbo.tblComputers.Computer
‎10-12-2010 11:31 AM
‎10-11-2010 07:59 PM
Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole = '3' Order By dbo.tblComputers.Computer
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now