?
Solved

How to query for Windows XP SP3

Posted on 2008-11-13
7
Medium Priority
?
974 Views
Last Modified: 2013-11-21
I am having more trouble than I should with this. Can anyone tell me what I am doing wrong with this query? I am trying to look for all computers with XP SP3 installed.  I am a beginner with making queries...
select SMS_G_System_OPERATING_SYSTEM.CSDVersion, SMS_G_System_OPERATING_SYSTEM.Caption from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.CSDVersion is like "%Service Pack 3%"

Open in new window

0
Comment
Question by:L3370
  • 5
7 Comments
 
LVL 9

Author Comment

by:L3370
ID: 22952598
err here is the part i'm working with:
select SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_OPERATING_SYSTEM.CSDVersion from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%Microsoft Windows XP%" and SMS_G_System_OPERATING_SYSTEM.CSDVersion like "%Service Pack 3%"

Open in new window

0
 
LVL 30

Expert Comment

by:flubbster
ID: 22954167
Not sure if this is what you are looking for... here are several examples:

http://www.msfn.org/board/lofiversion/index.php/t122447.html
0
 
LVL 9

Author Comment

by:L3370
ID: 22954367
looking for an SMS query
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 9

Accepted Solution

by:
L3370 earned 0 total points
ID: 22954384
Resolved on my own.
0
 

Expert Comment

by:ISDNO
ID: 22974712
Could you post your solution?
0
 
LVL 9

Author Comment

by:L3370
ID: 22976156
The collection I was using to query for SP3 systems didnt contain any computers to return results. bonehead error.
0
 
LVL 9

Author Comment

by:L3370
ID: 22979962
The collection I was using to query for SP3 systems didnt contain any computers to return results. bonehead error.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    …
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question