Solved

Bulk accont & mailbox creation

Posted on 2010-11-28
7
829 Views
Last Modified: 2012-05-10
Hi-

I need to find the fastest AND easiest way to create about 30 Active Directory accounts with associated mailboxes on a Win Server 2008 server running Exch2007 SP1. Furthermore, I need to also create separate e-mail contacts which will point to my client contractors’ external  (SMTP) mailboxes; these users are all located at Gov't sites and also have a .gov e-mail address, in addition to these internal addresses I need to create. To be clear, I assume this will be a separate import process (#1 – create new internal user mailboxes for all 30 users….#2 – create SMTP mail contact in Exchange for the same 30 users)
Could the respondent to my query give me clear instructions on how to do this? Please do not point me to other sites that claim to know how to do it, since I am pretty technical, have followed the leads I have found already, but I keep getting error messages in the Exch Mgmnt Shell when I try to import the CSV file I created based on instructions I found. So, rather than trying to fix what's not working, can you please send me a fully functional CSV file (or paste headers here) AND the proper ExShell syntax for BOTH of these tasks? It's ok if all accounts have the exact same password, though I want to make sure they these newly created accounts are NOT flagged with a “User must change password at next logon” - we have actually found that creating accounts this way does NOT allow OWA users to even log in the first time, since this is the only way that remote users access their internal mailbox from afar using OWA.

Can you help with working CSV headers (and an example row) to do both of these imports into the Ex (power) shell?

Thanks in advance.
Brian
0
Comment
Question by:ethernet69
  • 4
  • 3
7 Comments
 
LVL 18

Expert Comment

by:suriyaehnop
ID: 34231272
To create bulk mailbox:

CSV format:

Name      Fistname      Lastname      Alias      Account      Database      Org      Primary      Company


To create bulk contacts:
Import-Csv "C:\new user.csv" | foreach { New-Mailbox -Name $_.Name -FirstName $_.firstname -LastName $_.lastname -Alias $_.alias -SamAccountName $_.sameaccount -Initials $_.initial -Database $_.database -OrganizationalUnit $_.org -UserPrincipalName $_.primaryaddress -Password $temp -ResetPasswordOnNextLogon:$false }

Open in new window

Import-Csv c:\ste.csv | foreach { New-MailContact -FirstName $_.firtname -LastName $_.lastname -Name $_.Name -Alias $_.alias -ExternalEmailAddress $_.mail -OrganizationalUnit $_.OU }

Open in new window

Create-bulk-Mailbox.csv
Create-Bulk-Contacts.csv
0
 

Author Comment

by:ethernet69
ID: 34235695
I also need to specify the OU to which the new user(s) belong when creating the AD account and mailbox via the PowerShell script. How does this change the script and the CSV headers? Can you give an example of the headers in line 2 of the CSV?
0
 
LVL 18

Expert Comment

by:suriyaehnop
ID: 34236864
Import-Csv "C:\new user.csv" | foreach { New-Mailbox -Name $_.Name -FirstName $_.firstname -LastName $_.lastname -Alias $_.alias -SamAccountName $_.sameaccount -Initials $_.initial -Database $_.database -OrganizationalUnit $_.org -UserPrincipalName $_.primaryaddress -Password $temp -ResetPasswordOnNextLogon:$false

This script include Organizational Unit.

Here is what CSV look like..
Create-bulk-Mailbox.csv
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:ethernet69
ID: 34238313
Thank you Suriya....what does the "org" classification do? How is "org" different from adding them to the correct "OU" during import?
0
 
LVL 18

Expert Comment

by:suriyaehnop
ID: 34245945
The "org" is just excel header name. You can put another name. Let say that, you want to put 2 new user to different OU, in org column, you have specigy the path for that OUs. please refer to excel sheet.

      

Name	Fistname	Lastname	Alias	Account	Database	Org	Primary	Company

Suriya	Suriya	Eh Nop	suriya	Suriya	Server01\SG3\DB3	contoso.com/North OU/marketing	suriya@contoso.com	

User 01	User	1	user01	user01	Server01\SG3\DB3	contoso.com/South OU/sales	user01@contoso.com

Open in new window

Create-bulk-Mailbox.csv
0
 

Author Comment

by:ethernet69
ID: 34247403
Thank you....what would be the proper syntax (in the PS script, as well as the import file) to add a user to a distribution list during the mailbox creation process?
0
 
LVL 18

Accepted Solution

by:
suriyaehnop earned 500 total points
ID: 34253997
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Utilizing an array to gracefully append to a list of EmailAddresses
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now