• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

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

0
mgupta_22
Asked:
mgupta_22
1 Solution
 
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
 
mgupta_22Author Commented:
It helped
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now