[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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