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")