SCCM Report for User Device Affinity

Updated: Here is a better sccm query for creating a device collection based on primary users: https://adminsccm.com/2018/10/07/creating-device-collections-based-on-users-and-vice-versa/   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, … Read more