Exporting All Active Directory User Email addresses

[frank s]

Need to generate a list of all smtp addresses within my active directory
environment.
I've come accross a bunch of sites, but I find the syntax they use is a
little out of my league.
I would be very happy if someone could maybe even provide me with some
example commands exporting to excel or something.
Or if anyone has any other solution, please let me know.

Thanks in advance.

 

[Guest]

Frank - Check
http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept04/hey0924.mspx.
This script can be used as a starting point, the attribute you want is
mailNickname.

 

[Joe Richards [MVP]]

What exactly do you want? Do you want addresses matched up with DNs or
sAMAccountNames or mailNicknames or what?

If you just want a list of all SMTP addresses you can do the following

adfind -sc exchaddresses:smtp -list

If you want addresses matched up with DNs in CSV format you want

adfind -sc exchaddresses:smtp -csv

If you want the addresses with DNs and sAMAccountNames and/or mailNicknames or
other attributes in CSV format you want

adfind -sc exchaddresses:smtp sAMAccountName mailNickname -csv

You can get adfind from my site, just go to google and type adfind and click I
feel lucky and it will take you to the adfind site with the download.

joe



--
Joe Richards Microsoft MVP Windows Server Directory Services
Author of O'Reilly Active Directory Third Edition
www.joeware.net


---O'Reilly Active Directory Third Edition now available---

http://www.joeware.net/win/ad3e.htm

 

[Joe Richards [MVP]]

mailNickname is not necessarily the same as your SMTP address. It might be, but
there is no guarantee, it depends entirely on the recipient policy and other
additional addresses that have been set.

--
Joe Richards Microsoft MVP Windows Server Directory Services
Author of O'Reilly Active Directory Third Edition
www.joeware.net


---O'Reilly Active Directory Third Edition now available---

http://www.joeware.net/win/ad3e.htm

 

[frank s]

What exactly do you want? Do you want addresses matched up with DNs or
sAMAccountNames or mailNicknames or what?

I want to export all SMTP addresses and the account they are associated to
withing the entire AD 2000 domain.
I hope that helps.

 

[frank s]

What exactly do you want? Do you want addresses matched up with DNs or
sAMAccountNames or mailNicknames or what?

If you just want a list of all SMTP addresses you can do the following

adfind -sc exchaddresses:smtp -list

Thanks Joe, this tool is great. The above syntax did the trick!