Export Email address/Aliases from AD

Hi there,

We've been asked by our Email scanning/filtering company to provide them with a list of email addresses from our OU.

I am looking for a way to export a CSV etc of all the email addresses (primary and secondary and aliases) from Microsoft Exchange or Active Directory. Is there a quick/easy method?
pbgormleyAsked:
Who is Participating?
 
NeiphinConnect With a Mentor Commented:
Ok, lets try a different approach.
Download adfind from

http://smtp25.blogspot.com/2007/09/finding-proxyaddresses-with-adfind_09.html

http://joeware.net/freetools/tools/adfind/index.htm

The command to run is (this will dump out users, contacts etc).

c:>c:>adfind -b dc=dc1,dc=dc2,dc=dc3,dc=dc4 -f (proxyaddresses=smtp:*) name proxyaddresses


Hope this helps. If not, well.................

Regards
0
 
LegendZMPrincipal Security ArchitectCommented:
0
 
ormerodrutterCommented:
The easiest way is to go to your Exchange server, open AD Users and Computers, click to expand the User container. Go to VIEW and select Add/Remove Columns and add the Email addresses and Email Aliases columns (or whatever you need).

Right click on the User container and choose Export List. You can select to export to either .txt file or .csv file (change the file type).
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
pbgormleyAuthor Commented:
Thanks mate. That's almost it.

I have quite a few users with aliases, ie joe.bloggs@domain.com may also have another SMTP address as joe@domain.com, is there any way to export/extract these?

Cheers
0
 
LegendZMPrincipal Security ArchitectCommented:
0
 
pbgormleyAuthor Commented:
I tried that also and i keep getting an error at this part 'mailnickname,proxyaddresses' ??
0
 
ormerodrutterCommented:
You can use CSVDE or LDIFDE utility to export user account detail.
http://www.ss64.com/nt/csvde.html
http://support.microsoft.com/kb/327620
0
 
NeiphinCommented:
Try this CSVDE  command, It should give you all that you need in a csv file.

csvde -r "(objectclass=user)" -l dn,mailNickname,mail,ProxyAddresses -f c:\export.csv


regards
0
 
pbgormleyAuthor Commented:
Thanks mate, tried that and its about 90% there but it doesn't export the email aliases that some users have.....

example.... joe.bloggs@domain.com also has another SMTP address as joe@domain.com that doesn't get exported, in some circumstances a user may 2 or 3 more.... I need them all unfortunately....
0
 
NeiphinCommented:
proxyaddresses should export all SMTP addresses. It does for me even if a user has several SMTP setup.
0
 
pbgormleyAuthor Commented:
I used the code you suggested & it created the export.csv fine but only primary email addresses have been exported, i have the csv open in front of me.
0
 
NeiphinCommented:
that is odd,

Try the following, (only proxyaddresses)

csvde -r "(objectclass=user)" -l ProxyAddresses -f c:\export.csv

If that is no good try, (this will dump out all possible attributes)

csvde -r "(objectclass=user)" -f c:\AllADobjects.csv

Regards
0
 
pbgormleyAuthor Commented:
Really frustrating i know...

tried both and same result :(
0
 
NeiphinCommented:
ok, let me check here and come back to you later.
0
 
pbgormleyAuthor Commented:
Cheers, I'd appreciate that.... Regards
0
 
LegendZMConnect With a Mentor Principal Security ArchitectCommented:
This website has a clip of code that will do exactly what you want. You just copy the code, modify it to your domain's need, save it as a VBS script and execute from command prompt.

http://www.petri.co.il/forums/showthread.php?page=2&t=7690

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.