
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-08-2011 11:06 AM
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.
- win xp x64 sp2 (current servicepack)
- win xp x86 sp2 (outdated servicepack)
and i only want to list x64 computers.
Labels:
- Labels:
-
Product Feedback
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-23-2011 03:57 PM
To list all x64 XP computers with SP2, please use the following report:
It's not possible to include this report in the OS list at the top of your report dashboard though.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2011 11:41 AM
No.
This report shows me only x64 xp computers with sp1 and i want to list all x64 xp with sp2.
This report shows me only x64 xp computers with sp1 and i want to list all x64 xp with sp2.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2011 07:48 PM
Isn't it easier to click on report "not latest service pack XP (x64)"?
