Skip to content

Instantly share code, notes, and snippets.

@techraf

techraf/Create a Company Structure

Last active November 4, 2016 07:10
Show Gist options
  • Save techraf/d3c29638652008988310ced5407a5f0e to your computer and use it in GitHub Desktop.
Save techraf/d3c29638652008988310ced5407a5f0e to your computer and use it in GitHub Desktop.
Download ZIP
Create Demo Domain
Raw
Create a Company Structure
# This creates a demo company structure
Raw
CreateCompanyUsersOU.ps1
New-ADOrganizationalUnit -Name "Company Users"
Raw
ImportOffices.ps1
Import-Csv .\offices.csv -Delimiter ";" | New-ADOrganizationalUnit -PassThru
Raw
ImportUsers.ps1
import-csv -path .\users.csv -Delimiter ";" | foreach {
$givenName = $_.name.split()[0]
$surname = $_.name.split()[1]
new-aduser -name $_.name -enabled $true -givenName $givenName -surname $surname -accountpassword (convertto-securestring $_.password -asplaintext -force) -changepasswordatlogon $true -samaccountname $_.samaccountname -userprincipalname ($_.samaccountname+"@ad1.osaka.machol.net") -city $_.city -department $_.department -Path $_.path
}
Raw
offices.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 4. in line 1.
Path;Display Name;Name;City;State;Description;Country
OU=Company Users,DC=ad1,DC=admgmt,DC=demo;Osaka;Osaka;Osaka;Osaka-fu;main Asian office;JP
OU=Company Users,DC=ad1,DC=admgmt,DC=demo;Warsaw;Warsaw;Warsaw;mazowieckie;main European office;PL
OU=Company Users,DC=ad1,DC=admgmt,DC=demo;Seattle;Seattle;Seattle;Washington;main American office;US
Raw
users.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 5. in line 1.
Name;samAccountName;Path;Password;City;Department
Frederic Chopin;fchopin;OU=Warsaw,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Warsaw;marketing
Tadeusz Kosciuszko;tkosciuszko;OU=Warsaw,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Warsaw;sales
Mikolaj Kopernik;mkopernik;OU=Warsaw,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Warsaw;IT
George Washington;gwashington;OU=Seattle,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Seattle;finance
Elvis Presley;epresley;OU=Seattle,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Seattle;finance
Steve Jobs;sjobs;OU=Seattle,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Seattle;IT
Hideyoshi Toyotomi;htoyotomi;OU=Osaka,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Osaka;management
Akira Kurosawa;akurosawa;OU=Osaka,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Osaka;design
Yukichi Fukuzawa;yfukuzawa;OU=Osaka,OU=Company Users,DC=ad1,DC=admgmt,DC=demo;ZRRo1OYIh7YGijdjjN76NmqDnjKEg7krQc;Osaka;IT
Raw
Wrapper.ps1
New-Item c:\canary1 -type directory
.\CreateCompanyUsersOU.ps1
New-Item c:\canary2 -type directory
.\ImportOffices.ps1
New-Item c:\canary3 -type directory
.\ImportUsers.ps1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment