Day: July 15, 2014

  • Transform AD User Group to Device Collection

    AD: The AD Computer object must fill in the ManagedBy field with the Primary User The AD User must be added to a AD User Group SCCM: System Discovery has to be extended with the ManagedBy field User Discovery has to be extended with the Distinguishedname field SCCM Collection Query: 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 where…