How to Export the Exchange 2010 Default Global Address List (GAL)

Home > Blogs > Exchange Server > How to Export the Exchange 2010 Default Global Address List (GAL)

How to Export the Exchange 2010 Default Global Address List (GAL)

Like This Blog 4 Mike Pfeiffer
Added by May 9, 2012

Looking to export your Exchange 2010 default global address list (GAL) to an external file? This is supported natively right from the Exchange Management Console (EMC). Just navigate to the Recipient Configuration node in EMC, and select the recipient type. Then from the actions pane, you can select the "Export List" option and dump the data out to a CSV or text file.

You can also customize the fields. Before exporting using EMC, you'll want to go up to View > Add Remove Columns and choose which properties you want in your file. Keep in mind that with this method, you'll need to go to each recipient type, such as mailbox, distribution group, mail contact, etc. and export your list.

Another option is the Exchange Management Shell. If you take a look at the default global address list, you'll notice it already has a filter defined:

You can use this filter to generate your report using the Get-Recipient cmdlet. This takes mailboxes, contacts, groups, and mail-enabled public folders into account for you.

To generate a report using this filter, use the following:

You might also want to filter out recipients that have the HiddenFromAddressLists enabled property set to true. You could modify the filter, or you could just use Where-Object and do it after the fact:

It will be a lot faster, especially in environments with lots of mailboxes, if you use a server side filter to exclude those hidden recipients:

What you should end up with is something you can open in Excel that looks like this:

You can select additional properties if needed, just add them when calling Select-Object. Also, you may want to dump this data out to HTML. If that is the case, replace Export-CSV with ConvertTo-Html and redirect the output to a file with a .html extension. Finally, keep in mind that the Get-Recipient will return 1000 objects by default. You can override this by setting its -ResultSize parameter to a specific value, or to Unlimited.

Enjoy!

Mike Pfeiffer – Microsoft MVP
Director of Unified Communications
Interface Technical Training

Videos You May Like

Creating Users and Managing Passwords in Microsoft Office 365

0 581 3

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

JavaScript for C# Developers – September 24, 2014

0 458 3

Is JavaScript worth taking the time to learn if I’m a server-side .NET developer? How much of C# carries over to JavaScript? In this recorded video from Dan Wahlin’s webinar on September 24,2014, Dan answers these questions and more while also discussing similarities between the languages, key differences, and the future of JavaScript (ES6). If … Continue reading JavaScript for C# Developers – September 24, 2014

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 545 3

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

See what people are saying...

  1. Avatar KERR

    Thanks this was useful

  2. Avatar Tom B

    Note that the EMC method described above does NOT export a copy of the GAL, at least in Exchange 2010 SP3. If you have mailboxes that have the “Hide from Exchange address lists” box checked, they will still export. And, that’s not something you can filter for.

  3. Avatar John Wilson

    Oh, never mind; I thought you were only doing Mailboxes.

  4. Avatar John Wilson

    Doesn’t the GAL include contacts and mail-enabled public folders and distribution lists?

Share your thoughts...

Please fill out the comment form below to post a reply.