?
Solved

global address book export

Posted on 2011-04-19
11
Medium Priority
?
645 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
0
Comment
Question by:pma111
  • 6
  • 5
11 Comments
 
LVL 9

Accepted Solution

by:
Ken Fayal earned 1000 total points
ID: 35422964
If you are sure that none of the mailboxes are hidden from the "GAL" the global address book, then it can work.  But it is possible to hide addresses from the GAL using the EMC.  

The GAL is the list of all mailboxes (barring those that are hidden from it).

The best bet is to export the mailbox list from inside the Exchange Management Console, but you didn't let us know what version of Exchange you are using so we can help you with the instructions for that.
0
 
LVL 3

Author Comment

by:pma111
ID: 35422983
exchange 2003 -

re ' mailboxes are hidden from the "GAL" '

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

Expert Comment

by:Ken Fayal
ID: 35423001
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.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 3

Author Comment

by:pma111
ID: 35423029
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.
0
 
LVL 9

Expert Comment

by:Ken Fayal
ID: 35423073
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
0
 
LVL 3

Author Comment

by:pma111
ID: 35423344
what version of outlook are you using their? we are outlook 2003
0
 
LVL 9

Expert Comment

by:Ken Fayal
ID: 35423376
Outlook 2010.  In Outlook 2003, there isn't a "More columns" option as shown there in the image?
0
 
LVL 3

Author Comment

by:pma111
ID: 35423395
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
0
 
LVL 9

Expert Comment

by:Ken Fayal
ID: 35423428
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
0
 
LVL 3

Author Comment

by:pma111
ID: 35423822
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.
0
 
LVL 3

Author Comment

by:pma111
ID: 35423836
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?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question