re: Creating an SMS Collection for Systems Missing a Patch

Phil Day — Fri, 17 Aug 2007 10:39:20 GMT

Thanks for the sql queries, the did the job for me. I did find that for Officeproducrs I needed to change the query a bit. It seems that Office patches dont have a Q number or an MS0n-nnn number collected in the database.

Si I created this query to do the same job for Office patches :

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.Status = "Applicable" and ( SMS_G_System_PATCHSTATE.Title like '%918419%' )

re: Creating an SMS Collection for Systems Missing a Patch

Mary B. — Fri, 06 Jul 2007 20:11:52 GMT

Just tweaked with patchstateEX and it was as good as new. Thanks for keeping this online. Saved me some time.