Active Directory Bulk User Creation 2012 R2

[Davit2005]

We used to use Dovestones but found it a bit limiting for what we wanted and actually do everything with PowerShell now.

[timbo343]

I use mikey magic active user manager, it works a treat with csv files however there isnt a download anymore but ive got the installer and free license details if anyone needs them.

[mavhc]

If I may plug my solution https://code.google.com/p/sims2ad/

 

VBScript, you'll need to edit it to your needs though. It's currently set up to read pupils from SIMS and staff from Excel

[itguy22]

Some great replies. Thanks everyone. This place really is a hive of knowledge!

[dblight]

I use mikey magic active user manager, it works a treat with csv files however there isnt a download anymore but ive got the installer and free license details if anyone needs them.

 

Any chance I could grab that from you please? Used to have a copy but God knows where I put it and cannot find it anymore!

[tmcd35]

If you are looking for a free solution I would recommend Wisesoft Bulk AD Users. I've used it for years and it works great, you create everything in Excel then it does the rest of the work for you.

 

BulkAD is good for mass altering existing accounts. He's spreadsheet: Account Management Spreadsheet is by far the best way I've come across at bulk creating AD accounts.

[IrritableTech]

Any chance I could grab that from you please? Used to have a copy but God knows where I put it and cannot find it anymore!

 

I could help you out... but I can't seem to PM you?

[timbo343]

Any chance I could grab that from you please? Used to have a copy but God knows where I put it and cannot find it anymore!

 

Send me a pm with your email address and ill send them over, it seems you have a choice who to PM .

[dblight]

I could help you out... but I can't seem to PM you?

 

Thanks, I have a copy now. Bizarrely my PM settings were wrong on here. Changed them now, thanks for the heads up :-)

 

Send me a pm with your email address and ill send them over, it seems you have a choice who to PM .

 

Nice one thanks, a great tool which should make my life a little easier now!

[afc123]

Could I request a copy of this please if that's okay with anyone? Never again am I doing it manually!

 

Thanks!

[timbo343]

Could I request a copy of this please if that's okay with anyone? Never again am I doing it manually!

 

Thanks!

 

PM me with your email address and ill send it over.

[ITJS2015]

Hi

 

I am just wondering if you can help me, I have used AD account manager to create bulk accounts for our schools but for some strange reason it creates the folders without the sharing and ntfs permissions. Now iv been through them all an set them but I would like a suggestion how to get around this if anyone can help?

 

Cheers

[zag]

The user folders should be created on first login, if not then check the root of the share permissions

[ITJS2015]

Its all correct but still no ntfs permissions. The file from softwise is accountmanagment.xls which only create the folder, is there any other way of a scrip to create AD accounts which associates with the home folder with the correct ntfs permissions ?

[sted]

not sure this is the latest revision but heres a version of my spreadsheet (I think the only revisions ive done recently are to along longer ou paths)

 

[ATTACH]30720[/ATTACH]

 

Its all correct but still no ntfs permissions. The file from softwise is accountmanagment.xls which only create the folder, is there any other way of a scrip to create AD accounts which associates with the home folder with the correct ntfs permissions ?

 

have a look at that spreadsheet it does ntfs perms see if you can either use that to do users from scratch or alter it to just do permissions

[ITJS2015]

 

This is the option of what im getting, I must be blind not to see if lol

 

EXAMPLE SHOT

[mikeyd101]

usercreate.txt

 

Here's my script to pick apart for some ideas (I've removed domain and OU information about our specifics).

 

we have sheet export exported from our student management system (TXiES), with additional fields added required for script. And additional requirement we have is that the kids have to sign an AUP (Acceptable Use Policy) for using computers.

 

This script requires the generation of unique username before running the script i use:

 

=CONCATENATE(SUBSTITUTE(SUBSTITUTE(F2," ",""),"-",""),LEFT(G2,1),LEFT(H2,1))

 

in excel to generate last name, first initial, middle initial.

 

I also embed the student id number into employee id AD field so we can tie the 2 together later, work out what class there in and set homedrive/directory. If student is returning student check the student id and reset the account expiry.

[themightymrp]

With a little bit of Powershell magic you can get it to create your usernames using a concatenate style AND if you have a CSV with different headings to what you need, you can create your own 'aliases' :-)

 

Concatenate magic to produce something like 15SmithA

 

@{n='username';e={"15"+($_.'Surname')+($_.'Forename').substring(0,1)}}

 

And to create your own alias for when your CSV heading is "First Name":

 

@{n='Forename';e=$_.'First Name'}}

[mikeyd101]

thanks, I originally had created the usernames in powershell, but found problem we seem to have lots of the same logins generated, lots of kids with same or similar names (one of the reasons for adding student ids in AD) so easier to automatic generate names in excel and remove dups before running the script.

[halbaradkenafin]

thanks, I originally had created the usernames in powershell, but found problem we seem to have lots of the same logins generated, lots of kids with same or similar names (one of the reasons for adding student ids in AD) so easier to automatic generate names in excel and remove dups before running the script.

 

Check out the script I put up here and I've got a short function which checks if the username exists already and then increments it, and does that till it finds an available name.

[3s-gtech]

[ATTACH=CONFIG]31457[/ATTACH]

 

This is the option of what im getting, I must be blind not to see if lol

 

EXAMPLE SHOT

 

Click the Permissions button and you should be able to set them there. I haven't got that to work for years though (been using this spreadsheet since 2008 or so). I just get it to create the user areas, then use NTFSFix to set the permissions in bulk and chown to set the ownership. Pretty straightforward, did all mine today including Exchange accounts, mail lists, group membership etc.

[Planehazza]

Hi all,

 

First post here. I've just started a new role in a school and have been tasked with the bulk creation of 300 new user accounts. I'm happy with using a PS1 script and referencing a CSV file with all the information. The problem, however, is our naming scheme. User Adam Adamson (Adamson, Adam) for example, will log on with AA1. However, this is a big site with 1900 students, so there are already several AA1, AA2 etc. accounts. What I need is a script that will query AD and add the new accounts, but name them as the next initials available. So if AA1, AA2, and AA3 exist, add Adam Adamson as AA4.

 

I'm guessing that I can modify the PS1 file from the OP but I'm not proficient enough with PowerShell to know if I can simply change the variables or is an entire new PS script required?

 

Thanks very much.

[Sephiroth]

For just an incremented suffix, your best bet would be to do something like this:

 

$Number = 1
$Name = "AA"
$Username = $Name+$Number

While (DSQuery User -SAMID $Username) {
   $Number++
   $Username = $Name+$Number
}

 

This will check AD for usernames of your convention and if it exists, increments the number by 1.

[yhttech]

Can someone post or PM me with a working link to Mikey Magic's tool?

[techy32]

Are you still looking for this tool?