MsExchange Blog Spot Telnet25

May 11, 2010

How to Dump/Export GAL to CSV file.

Filed under: General — telnet25 @ 9:41 pm

This is one of the most common request comes time to time, although there are many ways to accomplish the task I will show you one of the easiest one.

Log into one of your management server , Csvde.exe is a Microsoft Windows 2000 command-line utility, so open CMD prompted. Copy and paste below…..

CSVDE -f GalDump.csv -r objectCategory=person -l "displayName, title, telephoneNumber, department, mail"

 

image

 

All you need to do it to open the CSV file called GalDump.csv , the fiel will be on the same directory as you ran the command.

If you want everything use this one

CSVDE -f GalDumpAll.csv -r objectCategory=person

 KB555397

image

Tips

If you look at the first column you will figured out the attribute names and you can use this to modify the first CSVDE to fit to your needs

Best regards,
Oz Casey , Dedeal
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +
Http://smtp25.blogspot.com (Blog
Http://telnet25.spaces.live.com (Blog)
Http://telnet25.wordpress.com (Blog

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: