→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
stiwa
Champion Sweeper
because i have to click at win xp sp2 to show me the x64 computers, but this shows
- win xp x64 sp2 (current servicepack)
- win xp x86 sp2 (outdated servicepack)

and i only want to list x64 computers.
3 REPLIES 3
Hemoco
Lansweeper Alumni
To list all x64 XP computers with SP2, please use the following report:

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


It's not possible to include this report in the OS list at the top of your report dashboard though.
stiwa
Champion Sweeper
No.

This report shows me only x64 xp computers with sp1 and i want to list all x64 xp with sp2.
Hemoco
Lansweeper Alumni
Isn't it easier to click on report "not latest service pack XP (x64)"?