Mass addition of user accounts

13 Nov 2007 11:20 AM

Blackberry

Hi All

Just been asked to add user accounts to our Win2k3 server AD setup for each
child rather than each class so I have a list of 300-odd kids to enter - is
there a way I can automate this process as don't think my digits can handle
this sort of work!!??!

Thanks

13 Nov 2007 1:51 PM

Paul Bergson [MVP-DS]

How about bulk import via csvde?

http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Bulk.htm

--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"Blackberry" <info@NoSpamIt.com> wrote in message
news:e1FaiceJIHA.5684@TK2MSFTNGP06.phx.gbl...
> Hi All
>
> Just been asked to add user accounts to our Win2k3 server AD setup for
> each
> child rather than each class so I have a list of 300-odd kids to enter -
> is
> there a way I can automate this process as don't think my digits can
> handle
> this sort of work!!??!
>
> Thanks
>
>

13 Nov 2007 5:01 PM

Richard Mueller [MVP]

Blackberry wrote:

>
> Just been asked to add user accounts to our Win2k3 server AD setup for
> each
> child rather than each class so I have a list of 300-odd kids to enter -
> is
> there a way I can automate this process as don't think my digits can
> handle
> this sort of work!!??!

I have an example VBScript program to create users in bulk from the
information in a Microsoft Excel spreadsheet linked here:

http://www.rlmueller.net/CreateUsers.htm

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

16 Nov 2007 11:18 PM

Olaf Engelke [MVP Windows Server]

Hello,
Richard Mueller [MVP] wrote:

> Blackberry wrote:
>> Just been asked to add user accounts to our Win2k3 server AD setup
>> for each
>> child rather than each class so I have a list of 300-odd kids to
>> enter - is
>> there a way I can automate this process as don't think my digits can
>> handle
>> this sort of work!!??!
>
> I have an example VBScript program to create users in bulk from the
> information in a Microsoft Excel spreadsheet linked here:
>

another way to use the Excel sheet would be to use formulas to generate one
or more command lines for each user, which incorporates command line tools
like dsadd (and a calculated value for the initial password etc).
The formula would concatenate the values from the single columns together
with the parameters and after finishing one successfully you could use
autocomplete for getting the rows for the remaining accounts.
Mark these finished rows and copy / paste them into notepad.
Save as .cmd file and run it on an domain controller.
Do not forget logging capabilities, so that you easier can see, which
account creation may have failed.
Best greetings from Germany
Olaf