Hello all, I have a CM 2012 (RTM) environment where we use the following query to build a collection of machines that are pending reboot after being patched.
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 AS sms_r_system inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid where c.LastEnforcementMessageID = 9 We communicated to our users and then deployed a job to reboot the machines in this collection to help insure that a critical update had completed its installation. Unfortunately, there are some machines that were in the collection created by the query and remained in the collection even after repeated reboots. So we have some very upset clients screaming for our heads. I was thinking that if we modified the query so it only returned machines that do not show their OS boot time being after the LastEnforcementMessageID=9 was issued. My SQL / WQL query skills are pretty rudimentary so any help would be appreciated. I am also open to being told I am going about this all wrong, as long as that correction comes with instructions on how to do it correctly. :) Jeffrey L. Grant Infrastructure Technologist End User Computing [email protected]<mailto:[email protected]> San Diego Gas & Electric (858)613-5725 (Desk) (858)243-3996 (Cell) "It's a sorry man who can not invent an Oscar Wilde quote to fit his situation." ~ Oscar Wilde
