SMS Queries do not run

Hello,

This is my first time working with SMS so I know nothing about the product, yet, I need smoe information from the server.

I am trying to find out which of my 3000 clients is missing an MS patch. the problem is whenever I run the query, nothing happens, it runs for 2 seconds and stops.

Here's the query I am using :

select SMS_R_System.ResourceID,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client
from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_PATCHSTATE.QNumbers = "958644" and
SMS_G_System_PATCHSTATE.Status = "Applicable"

I don't lie to you, I found this query on the web somewhere, but I do not see anything wrong with it though, I might be mistaken though.

Any help would be highly appreciated.

Thanks
select SMS_R_System.ResourceID,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client 
from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId 
where SMS_G_System_PATCHSTATE.QNumbers = "" and 
SMS_G_System_PATCHSTATE.Status = "Applicable"

Open in new window

mgupta_22Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CRCoolCommented:
Under Software Updates - Compliance there is a report called "Compliance by Bulletin-ID and Qnumber". Have you used that and drilled down to see what machines are compliant with whatever your patch is?
0
DecKenCommented:
Have you downloaded and installed ITMU?
Follow this link to download and install it
http://technet.microsoft.com/en-us/sms/bb676783.aspx
Post back if you are still having issues and I will try to assist
Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mgupta_22Author Commented:
It helped
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.