Manually Exporting Users From Active Directory SafeConsole

Home » Active Directory Export Csv Powershell » Manually Exporting Users From Active Directory SafeConsole

Maybe your like

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 run in 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"

  1. Install Remote Server Administration Tools
  2. Open Control Panel -> Programs and Features -> Turn On/Off Windows Features
  3. Find "Remote Server Administration Tools" and expand it
  4. Find "Role Administration Tools" and expand it
  5. Find "AD DS And AD LDS Tools" and expand it
  6. Check the box next to "Active Directory Module For Windows PowerShell".Capture.PNG
  7. Click OK and allow Windows to install the feature
  8. Run the following code in a PowerShell terminal.
  9. The first line will load the AD module. (Make sure your user account has sufficient privileges)
  10. 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 activedirectoryGet-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.

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

Tag » Active Directory Export Csv Powershell