Censornet - internet filtering on your terms

Exporting e-mail addresses for MailSafe

July 14, 2011 • Customer Services       

Synopsis

Article

To export the e-mail addresses from your Active Directory to a CSV file, you should use the 'csvde' tool from Microsoft. This is included in the resource kit.

Run the following command on your Active Directory server:

csvde -d "OU=XXXX,DC=YYYY,dc=ZZZZ" -f emails.csv -r "(&(objectClass=user)(objectCategory=person))" -l " givenName, sn, mail"

Replacing XXXX with the container name e.g. Users, YYYY with the domain name e.g. mydomain and ZZZZ with the last part of the domain e.g. local. If my domain was ad2008.local and my users were in a container called Users, I would use: OU=Users,DC=ad2008,DC=local

This will produce a file called 'emails.csv' which you can e-mail to Technical Support for us to import for you.

Related articles