Export Global Address List (GAL) to CSV 1

[tkikkert]

I was looking for a way to export the GAL and found several articles in this forum about the LDIFDE command line. This does give the info but not in a column type fashion which is useful. I found CSVDE a lot more friendly. I needed a list of users and EMail address for a certain OU and I used this command:

CSVDE -f exchg.csv -d "OU=your_ou_name,DC=whatever,DC=whatever,DC=com" -r objectClass=user -l "name, mail"

There is more info on this at

http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Home.htm

Hope this helps someone out.

 

[sneeland]

Is there a way to convert the CSVDE output values for the CreatedDate? It shows a value that I can't figure out how to convert to a valid date.

Thanks!