This is a short description of queries in Microsoft Endpoint Configuration Manager for identifying machines with Office Professional 2016 installed.
Show Me MoreIn 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 MoreSetting 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 MoreUnder 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