Export information from Active Directory to a CSV file
I wanted to reboot all PC’s in a particular OU of our Active Directory structure. I found csvde which is a tool for exporting and importing data to and from Active Directory.
Once I got all of the computer names out and into a csv file I used the shutdown -i tool to past the computer names into and let it remotely reboot them.
Here are some sample csvde scripts for exporting various pieces of information:
Export everything (computers, users, groups etc. This could be a lot of records depending on your Active Directory so be careful.):
CSVDE -f exportFilename.csv
Export computer accounts from specified OU with only a few columns (just does dn, cn and name columns):
csvde -f ComputerNamesExport.csv -d “OU=OUName,DC=domain,DC=org” -r “(objectClass=computer)” -l “dn,cn,name”
- You can leave off the -l “dn,cn,name” and you’ll get all columns.
Export user accounts from whole domain with only the specified columns:
csvde -f \\server1\common\it\UserNamesExport.csv -d “DC=CBCO,DC=org” -r “(objectCategory=person)” -l “dn,cn,displayName,description,title,department,physicalDeliveryOfficeName,company”
- You can leave off -l and the rest to get all columns.