Problem:

I want to be able to target my software distributions to an Active Directory (AD) group. Can I create a Collection based on the membership of an AD Group?

Resolution:

First create your AD group containing the users or machines (not a good idea to create groups containing a mix of both), of the resources you want to target.

Then you need to create a new Query Based Collection that contains one of the following query statements depending on whether the AD group contains computers or users.

For Computers:

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 SystemGroupName = "<domain>\\<group_name>"

NOTE: There is no wrapping/ spaces after the commas (,)

For Users:

select SMS_R_User.ResourceID,SMS_R_User.ResourceType,SMS_R_User.Name,SMS_R_User.UniqueUserName,SMS_R_User.WindowsNTDomain from SMS_R_User where UserGroupName = "<domain>\\<group_name>"

IMPORTANT: You HAVE to have the double backslash (“\\“) between the domain and the group name.