We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

global address book export

Medium Priority
658 Views
Last Modified: 2012-06-21
Is there any easy command or way to export every entry in the email "global address book", with name and full email address? Where is it querying that information from, is it listing every corporate mailbox or just a select subset? I ideally want to write it out to excel to see every corporate mailbox we own
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
exchange 2003 -

re ' mailboxes are hidden from the "GAL" '

why would someone hide a mailbox from the GAL, could you provide some reasons why?

Commented:
I couldn't possibly begin to tell you why someone would do it.  I just know that there is a checkbox in the mailbox settings that says, "Hide from Exchange address lists".

Maybe it's a mailbox used by a messaging application that you don't want to have showing in the GAL - who knows.  All I know is that it's an option.

Author

Commented:
Ok no problem, re Exchange Management Console I dont have that available to me, found a tool that may do it :http://www.nirsoft.net/utils/sysexp.html

If I open up a "to" dialogue box in outlook it lists the GAL entries, but just an alias not the full user.surname@company.com which would help me no end.

Commented:
I don't know how you are going to do this without having access to EMC.  

If you open up a To dialog box, it should be showing options to show more columns.  One of those columns is the email address. To dialog box in Outlook To dialog box in Outlook

Author

Commented:
what version of outlook are you using their? we are outlook 2003

Commented:
Outlook 2010.  In Outlook 2003, there isn't a "More columns" option as shown there in the image?

Author

Commented:
There is but the email address column doesnt show the email address it has some text that ends in the users alias but no email address

Commented:
You can also check out ADSIEdit.  Too much to go into here, but if you have permissions, you can list exchange mailboxes with this too.  Maybe even export.

http://technet.microsoft.com/en-us/library/cc773354%28WS.10%29.aspx

Author

Commented:
Can you provide a step by step guide to do this with EMC (2003). I'll have our exchange admin export us a list to excel.

Author

Commented:
and in EMC is there a way to list all "public folders" that have been created, and the ACL for these folders? Can just anyone create a public folder or does it have to be an exchange admin?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.