MECM Query – Microsoft Office 2016
This is a short description of queries in Microsoft Endpoint Configuration Manager for identifying machines with Office Professional 2016 installed.
Show Me MoreMECM 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 != 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 MoreMicrosoft Intune Co-Management – SCCM Queries
Setting up Microsoft Intune Co-Management with your legacy SCCM environment is a critical part of the journey to Modern Management.What you will find is not all clients will successfully enroll for Co-Management.Because I find this stuff easier to action from SCCM, I use Collections to identify problem targets for remediation.You might find some of the […]
Show Me MoreInventory: (87d00224) Invalid message element (ReportType)
Under the SCCM Resource Explorer for a client, you may have no inventory data under the Hardware node.When the Hardware Node is empty, you may have an issue with the Computer PolicyIf it is not a new client, this data should be populated. SCCM uses this information to correctly add machines to collections based on database […]
Show Me More