FAQ  Search  Memberlist  Usergroups  Register  Profile  Private messages  Log in

Exporting All Active Directory User Email addresses

Forum Index -> microsoft.public.windows.server.active_directory

Author	Message
frank s Guest	Posted: Tue May 16, 2006 12:46 am    Post subject: Exporting All Active Directory User Email addresses 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.
Back to top
akeiii Guest	Posted: Tue May 16, 2006 1:46 am    Post subject: RE: Exporting All Active Directory User Email addresses 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. "frank s" wrote: Quote: 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.
Back to top
Joe Richards [MVP] Guest	Posted: Tue May 16, 2006 5:48 am    Post subject: Re: Exporting All Active Directory User Email addresses 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 frank s wrote: Quote: 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.
Back to top
Joe Richards [MVP] Guest	Posted: Tue May 16, 2006 5:49 am    Post subject: Re: Exporting All Active Directory User Email addresses 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 akeiii wrote: Quote: 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. "frank s" wrote: 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.
Back to top
frank s Guest	Posted: Tue May 16, 2006 10:23 pm    Post subject: Re: Exporting All Active Directory User Email addresses "Joe Richards [MVP]" <humorexpress@hotmail.com> wrote in message news:OVA6PrIeGHA.3484@TK2MSFTNGP04.phx.gbl... Quote: 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. Quote: 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 frank s wrote: 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.
Back to top
frank s Guest	Posted: Tue May 16, 2006 11:54 pm    Post subject: Re: Exporting All Active Directory User Email addresses "Joe Richards [MVP]" <humorexpress@hotmail.com> wrote in message news:OVA6PrIeGHA.3484@TK2MSFTNGP04.phx.gbl... Quote: 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! Quote: 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 frank s wrote: 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.
Back to top
Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

	Forum Index -> microsoft.public.windows.server.active_directory	All times are GMT
Page 1 of 1