Configuration Manager 2012: Finding Assets Without a Primary User Defined

If you are using the primary user attribute to define some of your software installations in CM2012 it can be useful to audit the deployed devices in your environment to help troubleshoot issues with application deployment. I use primary user to help define software delivery such as having FAT packages only install on primary devices or have App-V applications only fully cache on a primary device. I quickly put together a query  you can use to check Windows 7 machines to see if they have a primary user assigned or build a collection of machines the helpdesk can look at when trying to troubleshoot application delivery issues.

Select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonTimestamp from  SMS_R_System where SMS_R_System.IsAssignedToUser = "False" and (SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.1" or SMS_R_System.OperatingSystemNameandVersion = "Windows 7 Entreprise 6.1")


This post is locked
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ