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 :
from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.Re
sourceID = SMS_R_System.ResourceId
umbers = "958644" and
atus = "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.
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"