microsoft exchange: add email

afaik, microsoft exchange server 2003 does not have any utility to add email from other computer. it will make an email administrator confused if he was asked by their boss to add email address for the new employee that has just joined. or if you work on an internet service provider, and your company using microsft exchange server as the email server for the customer, every new customer register the account, you must go to the server, remote the server, and open the active directory users and computers window, to add a new user. imagine if there are more than 250 customer waiting for the email address that they have subscribed for. you will get 'ngelu bin pusing tujuh keliling' handling those email creation manualy.

microsoft active directory, has some command line interface to import or export active directory objects. it called csvde. with csvde, we can import/export from/to a bulk of csv file.

ok, lets make it quick, create a csv file like this:

DN,objectClass,name,homeMDB,cn,displayName,mail,givenName,proxyAddresses,sAMAccountName,sn,userAccountControl,userPrincipalName,homeMTA,msExchHomeServerName,mailNickname,countryCode,c,l,homePhone,mobile,telephoneNumber,co,wWWHomePage
"CN=kang parmin,OU=Users,DC=kucing,DC=net",user,kang parmin,"CN=Mailbox Store (SERVER100),CN=First Storage Group,CN=InformationStore,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",kang parmin,kang parmin,kangl@kucing.net,kang,SMTP:kangl@kucing.net;X400:c=us\;a= \;p=kucing\;o=Exchange\;s=parmin\;g=kang\;,kangl,parmin,512,kangl@kucing.net,"CN=Microsoft MTA,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",/o=kucing/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=SERVER100,kangl,376,ID,Jakarta,62-214534545,62-21345345,62-214534545,INDONESIA,www.kucing.net
"CN=mang parmin,OU=Users,DC=kucing,DC=net",user,mang parmin,"CN=Mailbox Store (SERVER100),CN=First Storage Group,CN=InformationStore,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",mang parmin,mang parmin,mangl@kucing.net,mang,SMTP:mangl@kucing.net;X400:c=us\;a= \;p=kucing\;o=Exchange\;s=parmin\;g=mang\;,mangl,parmin,512,mangl@kucing.net,"CN=Microsoft MTA,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",/o=kucing/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=SERVER100,mangl,376,ID,Jakarta,62-219879878,62-21878345,62-219879878,INDONESIA,www.msn.co.il
"CN=lek parmin,OU=Users,DC=kucing,DC=net",user,lek parmin,"CN=Mailbox Store (SERVER100),CN=First Storage Group,CN=InformationStore,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",lek parmin,lek parmin,lekl@kucing.net,lek,SMTP:lekl@kucing.net;X400:c=us\;a= \;p=kucing\;o=Exchange\;s=parmin\;g=lek\;,lekl,parmin,512,lekl@kucing.net,"CN=Microsoft MTA,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",/o=kucing/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=SERVER100,lekl,21,ID,Jakarta,376-212424478,62-21654654,62-212424878,INDONESIA,www.cnn.com
"CN=pakde parmin,OU=Users,DC=kucing,DC=net",user,pakde parmin,"CN=Mailbox Store (SERVER100),CN=First Storage Group,CN=InformationStore,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",pakde parmin,pakde parmin,pakdel@kucing.net,pakde,SMTP:pakdel@kucing.net;X400:c=us\;a= \;p=kucing\;o=Exchange\;s=parmin\;g=pakde\;,pakdel,parmin,512,pakdel@kucing.net,"CN=Microsoft MTA,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",/o=kucing/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=SERVER100,pakdel,376,ID,Jakarta,62-218768767,62-21456658,62-218768767,INDONESIA,www.cnn.com
"CN=mbah parmin,OU=Users,DC=kucing,DC=net",user,mbah parmin,"CN=Mailbox Store (SERVER100),CN=First Storage Group,CN=InformationStore,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",mbah parmin,mbah parmin,mbahl@kucing.net,mbah,SMTP:mbahl@kucing.net;X400:c=us\;a= \;p=kucing\;o=Exchange\;s=parmin\;g=mbah\;,mbahl,parmin,512,mbahl@kucing.net,"CN=Microsoft MTA,CN=SERVER100,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=kucing,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=kucing,DC=net",/o=kucing/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=SERVER100,mbahl,376,ID,Jakarta,62-215645446,62-21978879,62-215645446,INDONESIA,www.disney.com

and save it to test1.csv

from the command line, go to the directory that you save test1.csv, and run

csvde -i -f test1.csv

this command, will create all that 5 users in the active directory in the csv file, as well as the email address.

oops, i forgot to tell you, you must disable the password requirements in windows domain security policy. (open domain security policy -> account policies -> password policy, set Minimum password length = 0, and set Password must meet complexity requirements to Disabled). and run again

csvde -i -f test1.csv

ok, now that 5 users and email address already created, but, with no password.
to set the password, you can use net command:

net user mbah1 Pa$$w0rd

this command will set the user and email password for user mbah1 to Pa$$w0rd.

and if on the csv file is containing 5 users, you must type that command 5 times.
yes, it is not effective, but this is the only way .... sorry.

but, don't wory, i will give you the solution of this f***ing hell problem.
ofcourse not in this page, i will write it later.

salaam