Create SCCM Collections Based on Active Directory OU

Benoit LecoursSCCM12 Comments

Many organizations still use Active Directory groups or Organisational Unit to do operational tasks in SCCM. Sometimes, they use OU to classify their devices or users. Many will tell that it’s not the most efficient way to do it but it’s effective for some. This blog post will describe how to do a script to create SCCM Collections based on AD OU.

We’ve seen many Active Directory having thousand of different Organisational Units and been asked to create SCCM collection based on those Active Directory OU. This has to be a tedious and boring task. PowerShell to the rescue!

I searched on the internet and found some script that was useful but decided to pimp it a bit to make it really easy for any administrators to create an SCCM collection based on OU.

The script will :

  • List all Organisational Unit (OU)
  • Prompt the Administrator to select the topmost OU where they want to start creating
  • Prompt the Administrator for a folder name
  • The script will create the folder in SCCM
  • The script will create 1 collection per OU from the start OU and will create 1 collection for all OU under the start OU. See the example below if it’s unclear.
  • The script will move collection in the specified folder

We tested the script on our lab server which is running SCCM 1910. The script will work on any SCCM version.

SCCM Collections AD OU – Example

In our lab, we have the following Active Directory structure :

SCCM Collections AD OU
  • I want to create 1 collection for all OU under SCD / Computers
SCCM Collections AD OU
  • I launch the script and select #5
SCCM Collections AD OU
  • The script will create 4 collections and put all members in it
  • SCD / Computers
  • SCD / Computers / Finance
  • SCD / Computers / Administration
  • SCD / Computers / HR

See it in action :

SCCM Collections AD OU

And the Result in SCCM :

SCCM Collections AD OU

Script Download

You can download this SCCM Collections AD OU script from my Microsoft Gallery page.

We hope this script will be useful for you. Let us know what you think in the comment section below.

12 Comments on “Create SCCM Collections Based on Active Directory OU”

  1. Hi,

    Is there a way to change this to import user groups instead?
    We have over 1200 applications and are moving to SCCM/MCEM, and would like to automate the process of AD User group collections including the dynamic rules for membership.

    Thanks!

    1. Hi,
      Idea noted, should be possible to do something similar for all groups under a specific OU…

      I Will look into it
      thanks
      Jonathan

  2. FYI,

    The script presumes that the program files for ConfigMan are install on a “D” drive and in a default folder path. I changed the line:

    Import-Module ‘D:\Program Files\Microsoft Configuration Manager\AdminConsole\bin\ConfigurationManager.psd1’

    to:

    Import-Module “$($ENV:SMS_ADMIN_UI_PATH)\..\ConfigurationManager.psd1”

    This gets around that. I install the program to a “P” drive on my boxes.

  3. What will the membership rules be? Will it be directly adding the current objects in each OU, or will it be setting a query, so it will remain updated as the AD OUs have objects added and removed? Thanks,

  4. Great work – but if i want to create collections from all security groups within the same OU what needs to be changed to the scripts??

    THX

Leave a Reply