→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎12-12-2011 04:43 PM
‎12-12-2011 05:01 PM
Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, Web40OSName.OSname,
tblOperatingsystem.ServicePackMajorVersion As [Current SP],
tblComputers.Lastseen
From tblOperatingsystem Inner Join
tblComputers On tblOperatingsystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where Web40OSName.OSname = 'Win 7'
Order By tblComputers.Computer
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now