SCCM Create user collection based on Active directory groups

SCCM Create user collection based on Active directory groups

To create a user collection based on Active directory (AD) groups, with SCCM 2012  you should :

1-Enable the folwing Discovery Methodes :

• Active Directory Group Discovery
• Active Directory User Discovery

2- On System configuration Manager 2012 , or SCCM 2012 R2 Go to "Assets and ComplianceOverviewUser Collections" and right click , then chose create user collection

3- Put the correct information (Name, et limiting collecion)

4-Add a Querry Rule 

5- CLik on Edit Query Statement, then SHow Query language

6- Put the query  :

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 like %Name of Ad Groupe %

Click ok then enjoy!!

Available link for download

download
alternative link download