Author Posts

June 14, 2018 at 2:04 pm

Hi All!
I need to create several organizational units in an existing one by import CSV file, using the command new-adorganisationalunit.
By using this command new-adorganisationalunit -name -path I can create just one at once, how can I use this with import-csv?
I'm new at scripting, can you help me?

June 14, 2018 at 3:05 pm

Hi there Elmira,

You can import the csv to a variable and then loop through it. Something like so:

$csv = Import-csv -Path %PATH%
ForEach($obj in $csv){

New-ADOrganizationalUntil -Name $obj.Name 

}

You'll need to map the appropriate properties (column name) to the appropriate parameter (-Parameter $Obj.ColumnName). I don't have a working example right now, but this should get you started if you want to learn. Let us know if you have any questions.

Also, some additional information on what each parameter expects for an input: https://technet.microsoft.com/es-es/library/hh852233(v=wps.620).aspx

June 14, 2018 at 11:01 pm

Also, you should leverage the -WhatIf switch to show you what the script would do and not actually create the OU's.

New-ADOrganizationalUnit-Name $obj.Name -WhatIf

This will let you check your work before you make changes and have to delete 100 OU's.

June 15, 2018 at 2:39 pm

^This. Read my post about PowerShell Math and the accidental creation of 2 million test accounts. 😛