Exporting GAL to Excel

I want to export the GAL from exchange, we have around 7 domains in the forest all over the world.
ive managed to export the entire GAL for the forest through adding all the GAL contacts to a PST then exporting to excel.

How do I export the gal for each domain so I can have a list of email addresses for each site.
I tried using CSVDE but its not very good and I have to log on to 7 different domain controllers to get the list and it pull off everything not just usernames and email addresses.

Can anyone help. Ive seen IMI GAL exporter but im not willing to spend £50 on this.

thanks guys.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Adrian WilsonTechnical Consultant / Project ManagerCommented:
This blog should help: http://www.intermedia.net/support/kb/default.asp?id=1211

Once you have the GAL as a private contacts folder you can do a normal export to CSV format.

Exchange 2007?

PS: Solving your problem isn't worth 50 quid to you? Oh dear ..
Adrian WilsonTechnical Consultant / Project ManagerCommented:
Ignore that, apologies, I didn't fully read your description.
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

you can open AD and configure an "AD query" based upon your search criteria.  for your case, you would do a search of all mail-enabled accounts in 1 single domain or multiple domains.  export it into a .csv file and open in excel - wa lah!
allawygAuthor Commented:
how would I do an AD query?
adfind might suffice .. adfind /help or google
allawygAuthor Commented:
what kind of command would i use to speicfy mailbox users only and to specify which domain.

is it like CSVDE I have to do this command on each DC ? thats what I want to avoid
if you've set your forest up so that your DC has a copy of each domain, you'll be able to run the query from 1 single DC.  

to run a query, open up AD on your DC.  at the top left hand corner, you should see "Saved Queries" right beneath the title "AD Users and Computers".  Right Click on Saved Queries, select New and select Query.  In here, give your search query a name and description and click the "Define Query" button.  in here you can define a query based off of 1 domain, or multiple domains, mail-enabled user accounts, etc.

here's a good write up on using the embedded AD query function:  http://www.windowsecurity.com/articles/Using-Saved-Queries.html

let us know if you have any questions!  thanks and good luck!


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
allawygAuthor Commented:
The query did bring up what I was looking for and exported fine, so thank you for that info.
I forgot to mention that I need a list to show display name and email address, this query only showed up the display name when exported.

I decided just to log on to each DC and run a csvde -r "(objectClass=user)" -d "dc=london,dc=domain,dc=local" -l displayName,mail -f c:\London.csv
and had to filter it to show only anything with an email address.

thanks guys for your help anyways.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.