Export Active Directory users into a CSV file

How do I export Active Directory user information to a CSV file?

To export user information from an Active Directory, you will need access rights to run the CSVDE tool on the Windows Server running the Active Directory in your domain.

  1. Open the command prompt (go to Start > Run, then type “cmd” and press Enter).
  2. Type in the following command:

CSVDE -f filename.csv -r (objectclass=person) -L "userPrincipalName, givenName, sn, mail"

This command will export into a file with name “filename.csv” the following information:

userPrincipalName – username
mail – e-mail address
givenName – first name
sn – last name

Once you have this file you can import users into your Brosix private IM network. Go to the Web Control Panel – Users – Import/Export tab.

You can also automate this process using Brosix LDAP Sync Tool

User account requirements

User accounts that you import into Brosix must meet these requirements:

  • Username – should be longer than 3 symbols and must contain only letters, numbers, underscore and ‘@’.
  • Password – should be longer than 3 symbols and must contain only letters, numbers and underscore.
  • E-mail – each user account should be assigned a valid e-mail address. This will allow us to send them their new account information and in case they forget their passwords they will be able to reset.