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?
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.
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 (,)
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.