Mass User Creation

[Bankesy]

Hello

 

Does anybody know of a way to create a list of new users in Active Directory from file?

 

I have all the new users details in a spread sheet and wondered if there was an easier way than setting them all up manually and individually.

 

Thank you

Edited July 4, 2014 by Dos_Box

[Norphy]

There are so, so many ways. Here is a Powershell script which can import users from a CSV:

 

Script Import users in Active Directory from CSV file

 

You can do it with VBScript

 

http://www.computerperformance.co.uk/vbscript/vbscript_user_spreadsheet.htm

 

Plus there are a plethora of third party applications which can do it too.

[FN-GM]

This is a really good and easy tool to do it - Account Management Spreadsheet

 

All easy, no scripts etc and a full GUI. Just copy and paste your data into it.

[3s-gtech]

^^Been using the Account Management spreadsheet for years now. It's ace - gives enough visual feedback while having flexibility and ease of use. Typical Wisesoft really.

[gtg93]

Flo user Manager is pretty good - free evaluation copy but you have to pay to use the full thing.

[TurnItOffAndOn]

Specops software do\did a free bit of software that allows you to use a spreadsheet/csv file and map columns to AD fields and import users on mass.

[jamesreedersmith]

active user manager, CSVDE, DSADD, LDIFDE, Powershell.....

 

The list goes on, you pays your money (or not as most are free) and you takes your choice!!!

[protocol]

Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

 

Edit: Just seen this thread is for server 2000/2003. We're using 2012.

[sted]

Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

 

Edit: Just seen this thread is for server 2000/2003. We're using 2012.

 

so as well as creating the folder you using something like \\server\%username%$ as the home folder rather than \\server\users$\group\%username% ?

[pcstru]

There are some example powershell scripts which do this Here.

[protocol]

so as well as creating the folder you using something like \\server\%username%$ as the home folder rather than \\server\users$\group\%username% ?

 

Correct.

 

There are some example powershell scripts which do this Here.

 

Will take a look thanks.

[sted]

might be easier to create them and write a quick n dirty batch file to create the shares assuming it sets the home dir attribute correctly

 

something like

 

dir d:\users\group > c:\temp\users.txt

for /f %%u in (c:\temp\users.txt\users.txt) do net share %%u$="d:\users\group\%%u" /grant:everyone,full /cache:none

[Sephiroth]

Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

 

Edit: Just seen this thread is for server 2000/2003. We're using 2012.

All of my user accounts are created in powershell. If you want some pointers or examples, just ask.

 

That applies to anyone who wants it

[sted]

heres my solution for doing it. Its a bit of a frankenstein spreadsheet. Basically fill it in and then copy and past the contents of the last 2 sheets to notepad and save as a batch file

 

users using dsadd v3 inc dollar.xls

 

all the school specific stuff is on sheet 1 and it auto generate usernames from name its currently set to last digit of you first initial first 5 or surname

[protocol]

All of my user accounts are created in powershell. If you want some pointers or examples, just ask.

 

That applies to anyone who wants it

 

That would be appreciated thanks. Ain't got a clue about powershell.

 

heres my solution for doing it. Its a bit of a frankenstein spreadsheet. Basically fill it in and then copy and past the contents of the last 2 sheets to notepad and save as a batch file

 

[ATTACH]25393[/ATTACH]

 

all the school specific stuff is on sheet 1 and it auto generate usernames from name its currently set to last digit of you first initial first 5 or surname

 

Really handy thanks.

[strawberry]

For file permissons look at wisesoft NTFS fix. Amazing piece of software.

[Dos_Box]

I'm going to rename this thread 'Mass User Creation' to make the title more relevant.

[HPlum78]

I am on the PS side of this as well, my though on this is if you have an MIS system in your organisation then why a spreadsheet? we use PS to connect to our MIS data. This means as a department we no longer get involved in account creation/ management. We have scripts that deal with this so when a staff member or student comes or goes it gets marked on the MIS database and the scripts sort it all out, even to the point of updating or staffs digital photo board.

[themightymrp]

I wrote a beast of a VBscript a few years back that reads the users from CSV. It also creates the share and sets permissions etc - it uses psexec.exe to create the share on the server (assuming I run the script from my desktop)