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"

Select allOpen in new window