SCCM
Collection Query: Computers with Pending Restart or other Update Enforcement
States
Create a query-based collection of
servers with pending reboot in Configuration Manager 2007 or 2012.
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_UpdateComplianceStatus
ON
SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid
WHERE SMS_UpdateComplianceStatus.LastEnforcementMessageID =
9
There are several other enforcement
states you can use instead by changing the number after ‘LastEnforcementMessage
ID =’ at the end of the query.
- 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
