MECM Query – Machines Pending A Restart
In Microsoft Endpoint Configuration Manager 1910, use the following query to identify machines pending a restart:
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 join sms_combineddeviceresources on sms_combineddeviceresources.resourceid = sms_r_system.resourceid where sms_combineddeviceresources.clientstate != 0
Apply this to whatever limiting collection you choose, I have found this useful in building up compliance for Desktop Analytics and Windows As A Service Insight Compliance.
This forms a part of the transition to Modern Management, and away from more on-prem console based activity
To engage DeployTech to drive your Modern Management adoption, please email email@example.com or call +61 499 333 973