MECM Query – Machines Pending A Restart

Microsoft Endpoint Configuration Manager

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 or call +61 499 333 973

Click Here to Leave a Comment Below