→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
‎09-08-2011 11:06 AM
‎09-23-2011 03:57 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description,
tblOperatingsystem.ServicePackMajorVersion As [Current SP],
tblComputers.Lastseen, Web40OSName.Compimage As icon
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 XP' And
tblOperatingsystem.ServicePackMajorVersion = '2' And Web40OSName.OScode =
'5.2.3790'
Order By tblComputers.Computer
‎09-15-2011 11:41 AM
‎09-12-2011 07:48 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now