Any one help me out to create the pending syatem restart collection based on Patch deployment in SCCM 2012.
Hi,
Here is a WQL query..
http://www.sccm-tools.com/tools/wqlqueries/WQLQueries-Patchrestartedneeded.html
Hey Jorgen
Thanks for your quick reply.
The above mention query was working fine in SCCM 2007 however this query is not working in SCCM 2012 :( .
yeah indeed,
I also want to find out the equivalent way to query this in SCCM 2012...
- Edited by grundlichkeit Thursday, October 04, 2012 12:26 PM
Try this one:
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
LastEnforcementMessageID LastEnforcementMessageName
1 Enforcement started
3 Waiting for another installation to complete
6 General failure
8 Installing update
9 Pending system restart
10 Successfully installed update
11 Failed to install update
12 Downloading update
13 Downloaded update
- Marked as answer by Praveen Kr. Sharma Tuesday, October 09, 2012 10:36 PM
Hello,
thank you for your help, the device collection works well.
Is there a way to create an email alert if this device collection contains more than zero computers?
Would be very useful to be alerted only if there's need of reboots instead of checking this device collection regularly...
And another question, in some other forum I read about the same way to create this kind of device collection, ony they proposed to insert a DISTINCT into the query to avoid duplicate entries. Is this necessary?
Thanks in advance and best regards,
Markus
No need to use "distinct". Colleval handles that automatically.
There's no built-in way to kick off an email if there's >0 members, but it can be scripted using the SDK or some SQL task.