Use the Get-AdUser Cmdlet to export a CSV list that includes DistinguishedName, EmailAddress and ObjectGUID. Depending on the size of your active directory and your filter properties, this command may cause a noticeable impact on your AD Server. Please take caution.  An example command would be:

 

Get-ADUser -Filter * -Properties DisplayName,emailaddress | export-csv ' ad_users.csv'


This command can be ran two different ways:


1) Through Powershell on a Windows server configured with an AD role.

2) Or on a windows 7 workstation connected to the Domain after installing "Remote Server Administration Tools"

  • Install Remote Server Administration Tools
  • Open Control Panel -> Programs and Features -> Turn On/Off Windows Features
  • Find "Remote Server Administration Tools" and expand it
  • Find "Role Administration Tools" and expand it
  • Find "AD DS And AD LDS Tools" and expand it
  • Check the box next to "Active Directory Module For Windows PowerShell".
  • Click OK and allow Windows to install the feature

Capture.PNG

  • Run the following code in a powershell terminal.
  • The first line will load the AD module. (Make sure you user account has sufficient privileges)
  • The second line will get all the AD users, along with their name and email address and save it as a CSV file.

  

import-module activedirectory
Get-ADUser -Filter * -Properties DisplayName,emailaddress | export-csv ' ad_users.csv'

  


Review your generated CSV File. It is very important that there is a "DC= " in the DistinguishedName for each entry.


Importing into SafeConsole


To import, go to  Manage Users and click the import button.  A popup will ask you to Upload your csv file and specify the formatting. 


PpJFeL19BQI4u8h9mXjxFKZui75-TMs-kg.PNG



After importing, a hard refresh might be required before the Users show up.