Reddit User Priestx (reddit post) is requesting help to create 3 OU with a group in each OU, and a user in each group.
Pre requirements:
Active Directory Powershell module
Permissions to manage Active Directory
Let's start off by playing around with the CSV file and ForEach loops.
Lets say your CSV files looks like this in Excel
Same file but open with Notepad
I saved the file on my desktop on a test VM, I then use the Import-CSV command to added it to the $CSVFile variable
Let's call the $CSVFile variable and see what we get.
In the CSV file we have 3 Headers:
OU,Group,User
We can call each of the values by
$CSVFile.OU
$CSVFile.Group
$CSVFile.User
Let's now play around with ForEach
You can use ForEach-Object or ForEach
Let's create a ForEach Loop for each of the values.
Again you can use ForEach-Object or ForEach to get the same results
Now that we got our CSV imported and had sometime to play with the ForEach loop lets use powershell to create a new OU.
First Import the Active Directory Powershell module
Let's test out the commandNew-ADOrganizationalUnit and create a test OU.
Look's like the command worked
Let's also try out the Get-ADOrganizationalUnit and find our new OU.
I ran the New-ADGroup command to create the group
It looks like by default the group was created in the Users OU
I ran the New-ADUser command to create the user
It looks like by default the group was created in the Users OU
Ok lets put everything together.
After playing around with the commands here is the final script.
Run Script as a .ps1
Comments