How to query the AD and display all user with seconday SMTP address
I want to generate a list of user that is still holding a seconday smtp address. I have pretty large AD user base, and I am only interested with the user in my country. Around 400 users. How am I able to query my ADand display only the user that still holding this secondary smtp address to belong to my country.This is what I have doneI first query for only the user that belong to my country by using the office location field. after the result is out I customise the view to display the email address. However I notice that it can only display the Default smtp address but not the secondary smtp address Any one can Help
January 18th, 2009 6:19am

Hi Jeffrey,Which version of Exchange do you use? Exchange 2003, Exchange 2007 or Exchange 2003+2007 in coexistence? Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2009 9:13am

No matter if you're running Exchange 2003 or 2007 you can use this script:http://exchangepedia.com/blog/2005/09/how-to-export-all-email-addresses-from.htmlHenrik Walther Exchange MVP | MCM: E2K7 | MCITP: EMA/EA | MCSE: M+S - MSExchange.org
January 18th, 2009 1:25pm

I am using exchange 2003 sp2
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2009 3:15am

I tried Henriks method in the lab (Exchange 2003 SP2), it works well Here, Id like to provide another method: Please run the command below in the cmd windows, it can export the secondary address as well csvde -f c:\All.csv -r objectClass=user -l "sn, givenName, proxyaddresses, DN, objectclass" After exported the file, please use Excel to view the output References: How to use Csvde to import contacts and user objects into Active Directory Introduction to CSVDE Switches
January 19th, 2009 7:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics