Wednesday, August 14, 2013

ActiveDirectory - Export Data to CSV

1. To export all data from Active Directory into a file called test.csv

csvde -f test.csv

2. Export data in a specific DN

csvde -d "OU=MyOU,DC=domain,dc=local" -f test.csv

3. Export with filters

csvde -f test.csv -r "(&(objectClass=user)(objectCategory=person)"

4. Export data with filters and specific DN

csvde -d "OU=Directors,DC=domain,dc=local" -f test.csv -r "(&(objectClass=user)(objectCategory=person)"

5. Get data of some fields only

csvde -d "OU=Directors,DC=domain,dc=local" -f test.csv -r "(&(objectClass=user)(objectCategory=person)" -l " givenName, sn, mail"

For more information, read this article: