Bulk create users in Exchange 2007

原创

黑锅 2009-09-02 21:47:34 博主文章分类：PowerShell ©著作权

文章标签 职场 exchange 休闲 文章分类 Exchange 服务器

©著作权归作者所有：来自51CTO博客作者黑锅的原创作品，请联系作者获取转载授权，否则将追究法律责任

Bulk create users in Exchange 2007

This script can be used to bulk create mailbox users. The data required to create these users is obtained from a comma separated variable (CSV) file of a particular format.

Your csv file should look like this

Line 1 Name,Alias,Password,Database,FQDN,OU
Line 2 john doe,john,234KJH0987*&*(&^,first storage group\mailbox database,contoso.com,users
Line 3 john doe,john,234KJH0987*&*(&^,first storage group\mailbox database,contoso.com,users
Line 4 john doe,john,234KJH0987*&*(&^,first storage group\mailbox database,contoso.com,users

## Import data from csv and store it in variable ‘data’$data = import-csv $args[0]
## Function to convert password into a secure string
function New-SecureString([string] $plainText)
{
   $secureString = new-object System.Security.SecureString
   foreach($char in $plainText.ToCharArray())
   {
      $secureString.AppendChar($char)
   }
   $secureString
}
foreach ($i in $data)
{
$ss = new-securestring $i.password
$upn = $i.alias + “@” + $i.fqdn
new-mailbox -Password $ss -Database $i.database -UserPrincipalName $upn -Name $i.name -OrganizationalUnit $i.ou
}