Do you have your packages set to send all messages? I don't know that would make any difference but it sure can't hurt.
[cid:[email protected]] ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Grant, Jeff Sent: Thursday, September 12, 2013 12:05 PM To: Config Forum ([email protected]) Subject: [mssms] Software updates reboot query 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 ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.png>>
