Creating collections in SCCM based on Active Directory OU Membership

2017-12-01T17:26:55+00:00 January 24th, 2011|Azure, Cloud|

To create a collection like this we need to setup a collection based on a query, the attributes that we will use will be..

Attribute Class: System Resource

Attribute: System OU Name

image

The Operator can be set to : is equal to

Values should be available when you click the value button.

If the values are not populated chances are is that the Active Directory System Group Discovery has either not been set or the OU you require has not been specified.

image

Enable the group discovery and add a Custom LDAP query to the OU/OUs in question, initiate a scan by selecting “Run discovery as soon as possible” in the polling schedule tab, you can monitor the progress of this in the adsysgrp.log

After this complete you should see the SMS table System_System_OU_Name_ARR table in the SCCM database will populate with data in the System_OU_Name0 column of the database.

The OU’s will now populate for the containers or domain you specified in the AD System Group Discovery LDAP queries.

image

Select the OU from the list, alternatively you can specify using the following query;

select *  from  SMS_R_System where SMS_R_System.SystemOUName = "<FQDNDomain>/<OUName>"

 

 

John Riseam

System Center Consultant

Risual Ltd