Bulk AD user creation

Hi all,

 

As usual at this time of year, the new intake needs to be added into AD.

 

I have previously used the Mikey Magic Active User Manager tool, but it looks like it is no longer available as the website is down.

 

Any good (and free) bulk user creation tools that are easy to use and set up? Don't really wish to go down the powershell or scripting route. I would prefer a csv import of users and then with a few clicks and options, have the accounts created and imported into AD.

I (and many others here) still use this Account Management Spreadsheet It works fine with Office 2016 on Server 2012 R2. Has been invaluable, only tool I've used for ten years now.

I've used this for years:

 

https://www.solarwinds.com/free-tools/active-directory-admin-tools-bundle

 

Lots of information on the forum - it's where found out about it and got support on using it.

+1 for the wisesoft tools. I have used these for a number of years now.

Although not free, we use Javelina Software ADUsers - it's very versatile for both creating and amending users (including scheduling the changes).

Creating users in bulk from a CSV out of SIMS is a good opportunity to get into Powershell. We started basic and now we have a script that is very customised to our needs and pretty much does everything, including groups, home drives, office365 and licensing etc. Probably not a lot of time now before term but it is something that could be worked on over the course of the year for next time.

 

Plus once you get to grips with Powershell, you can do a lot of other cool stuff too!

I just use CSVDE. Get the csv file right and then it's just "csvde -i -f filename.csv".

Powershell here. I have a script that is run on a schedule overnight. Pulls straight out of the HR system. Also bins people off the same way. Does all the other bits and bobs too like Home folders, O365 account setup, Exchange Mailbox stuff and what not.

We used to use DoveStones in a previous employment but then moved to powershell scripts because of various extra requirements. Dovestones support was brilliant whilst we were trialing and post purchase.

I know you want to avoid scripts, but this is ours, pretty basic and easily tweakable for username format etc, we have also added pager as we use that to identify on the biometric system:

 

Import-Module ActiveDirectory
$Users = Import-Csv -Path "C:\Scripts\User-Import.csv"            
foreach ($User in $Users)            
{   
   $Pager = $User.'Pager'     
   $Displayname = $User.'Firstname' + " " + $User.'Lastname'            
   $UserFirstname = $User.'Firstname'            
   $UserLastname = $User.'Lastname'            
   $OU = $User.'OU'            
   $SAM = $User.'SAM'            
   $UPN = $User.'SAM' + "@" + $User.'Maildomain'            
   $Description = $User.'Description'            
   $Password = $User.'Password'            
   New-ADUser -Name "$Displayname" -DisplayName "$Displayname" -SamAccountName $SAM -UserPrincipalName $UPN -GivenName "$UserFirstname" -Surname "$UserLastname" -Description "$Description" -AccountPassword (ConvertTo-SecureString $Password -AsPlainText -Force) -Enabled $true -Path "$OU" -ChangePasswordAtLogon $false –PasswordNeverExpires $true -server DOMAINCONTROLLER.YOURNETWORK.org.uk -OtherAttributes @{'Pager'=$User.Pager}            
}

 

Then you have a csv with the Fields pager, Firstname, Lastname, OU, SAM and password. Overtime I will add bits to it once I'm more competent in PS.