Exchange: Export GAL Using CSVDE

Summary:

One common request is "How do I export the contents of the GAL?" Unfortunately there are no native tools that simply export the contents without some work. There are some third party tools such as IMI GAL Exporter ver.3 which you can purchase for a few bucks. I have tested their trial version is appears to be a very neat utility. The other option is to use LDIFDE and CSVDE. Unfortunately, you have to know all the attributes listed in the GAL so you can export them out. I have provided the following CSVDE command to export most if not all the attributes in the GAL.

From a command prompt type the following command.Substitute the following string

"dc=corp,dc=company,dc=net" with your Fully Qualified Domain Name. Use Excel to open the file when complete.


C:\>csvde -r "(objectClass=user)" -d "dc=corp,dc=company,dc=net" -l disp
layname,title,description,company,department,assistant,
physicaldeliveryofficename,telephoneNumber,othertelephone,
mail,streetaddress,postofficebox,l,st,postalcode,co,homephone,
otherhomephone,pager,otherpager,mobile,othermobile,
facsimileTelephoneNumber,info,manager,memberOf -f c:\gal.csv

Connecting to "DC1.corp.company.net"
Logging in as current user using SSPI
Exporting directory to file c:\gal.csv
Searching for entries...
Writing out entries.............................................................




James Chong
MCSE M+, S+, MCTS, Security+
msexchangetips.blogspot.com


How useful was this article? Want to see a tip not listed? Please leave a comment.