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 :
- I want to create 1 collection for all OU under SCD / Computers
- I launch the script and select #5
- 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 :
And the Result in SCCM :
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.
Share this Post
Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 5 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.