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 != 0Apply 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 […]

Show Me More