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: http://www.techrepublic.com/blog/data-center/simplify-admin-tasks-by-exporting-active-directory-data-with-csvde/