Create SCCM Collections Based on Active Directory OU

Benoit LecoursSCCM3 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.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Share this Post

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

  1. 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

Your email address will not be published. Required fields are marked *