Bulk create AD accounts via Powershell

[maxrebo]

Hi,

I'm looking for a tool (preferably Powershell) to bulk create our AD accounts for our new intake. Could anyone share some ideas with me?

 

Thanks

[kevin_lane]

Export from a csv file from your mis or use something like salamander

[HPlum78]

I have never used Salamander but everyone on here says it a nice solution, We use MIM its free with our licencing from MS and this brings a whole host of other options for identity management.

 

I have also in the past use PowerShell to do the bit from MIS to AD, personally if i was not using either of the above I would say use PowerShell to connect to your MIS solutions DB directly rather than exporting out to a file.

[Chaniel]

I create our first intake using Powershell, each school is different but you'll need to plan out what you do with a user and adjust the script accordingly. With the first intake, I import a CSV and then run a ForEach loop to create the user in each line.

There is definitely more efficient ways to do this, but I wrote it how it appeared in my brain so...

Script workflow

 

Connect to Exchange, MS Online (MFA)

Set up initial variables

Start ForEach loop{

Import names from CSV, remove any superfluous spaces

Create username (Ours are in a weird format so this does some checking to make sure it's unique, if not it increments the number at the end)

Set password, additional variables

Create AD User

Add AD user to groups

Set AD Attributes

Create folder & apply permissions as necessary (Have to check the user had replicated to all DCs before doing this as otherwise it can error applying permissions. Would be way more efficient to do this step after the fact for each user tbh but I can't be bothered to change it)

Output to CSV}

 

Sync directory to O365

Sleep 2 mins

Start ForEach Loop{

Check if user has been synced to O365

Set MSOL location

Set MSOL licenses

}

Close PS Session

 

Sync to G Suite

I think it's best if you create the script yourself and then ask if you get stuck with any points if I'm honest, you'll be able to more effectively modify it for your school and processes.