Question Locked

Bulk Adding users with mailboxes in active Directory

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, I'm an I.T assistant at a small charity and I've got to add quite a few new users (70+) to our system via active directory. We use 2003 server and Outlook exchange 2003 server. Is there a way I can bulk add the users, so that the relevant information is filled in, including profile and terminal services profile paths AND a mailbox created for each user with preferably the Alias and Default e-mail address being filled in.

I've looked into using a VBscript that takes the data from a CSV file. This worked but only the logonname, first name, surname and password where filled in and no mail box was created.

I have a gut feeling I'm asking too much and most of what I want will only work if a specialist piece of software is purchased but I thought I'd ask anyway.

Many Thanks

Nick

7 replies

by why me worry?

for creating mailboxes

Look into Quest Software for a product called Wingra, as they have something to allow you to do bulk imports of users and mailboxes from CSV files, which can be created in Excel.

by me

I have created a script for myself that adds new users to AD from an Excel spreadsheet populating the following user attributes:
sAMAccountName
userPrincipalName
GivenName
SN
displayName
description
physicalDeliveryOfficeName
telephoneNumber
mail
title
department
company
homeDirectory
homeDrive
scriptPath
AccountExpirationdate
as well as creating a Mailbox, assigning a password and setting the account to force the user to change the password on first logon.

I cobbled it together using info from other scripts that I found via google (see links below) and used a list of the user attributes available at http://www.kouti.com/tables/userattributes.htm and http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm to add whatever attributes were relevant to my organisation.

Links:
http://www.computerperformance.co.uk/vbscript/index.htm
http://msdn2.microsoft.com/en-us/library/ms974568.aspx
http://noiesmo.dnsalias.net/article.php?story=20060829101639373
http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec06/hey1214.mspx

Hope this is of some help to you :-)

by snajafi

Have you added your script as a download anywhere? I can't see a link to download it.

This discussion is closed to new replies.