Thursday, September 1, 2016

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