Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

listing all e-mail addresses 2

Status
Not open for further replies.

striker77

Technical User
Jan 23, 2004
6
ZA
Hi All,

Here's the scenario: I need to produce a list of all e-mail addresses in use on the server.

Right...so i could go through all of the mailboxes noting the addresses used for each and produce a list at the end. This would be ok in a very small environment but for a large network etc would seem highly unrealistc.

Therefore is there or does anyone know of an automated way of doing this? Does exchange have a tool to query the database or such like?

Any other advice would be appreciated. (in relation to the topic obviously!).....

thanks

dave
 
Option 1:
View the GAL in Admin, click on the View menu, Columns..., add the Internet address to the view. On the File menu select the Save Window Contents option, this will save the right-hand-pane as a CSV file.

Option 2:
You can directory export (from Admin, or via a command prompt ot schedulable AT command) the 'E-mail Addresses' field, which is a multivalued field containing all primary email proxy addresses, and either extract the SMTP address from this field by splitting the field in Excel (Text to Columns option on Tools menu) or Notepad (search and replace on '%'), or by writing a small perl (or similar) script to do it for you.
 
cheers zbnet for the fast and spot on solution...absolute legend.

dave
 
Zbnet, the 'Save Window Contents' is greyed out after following the instructions you provided above. Do you know how I can re-enable that option?
 
You have to click in the right-hand pane for the option to be ungrayed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top