How to Export Specific Users from Active Directory


Native Auditing vs. Netwrix Auditor for Active Directory

We never share your data. Privacy Policy
Native Auditing Netwrix Auditor for Active Directory
Steps
  1. Create a new script with the following code (defining the “$Path” value) and run it:

    $Path = 'C:\Temp\ADUsers.csv'
    Get-ADUser -Filter * |
    Select-Object Name,Enabled,UserPrincipalName | Export-Csv -Path $Path –notypeinformation

  2. Open the file produced by the script in MS Excel.

    Sample report:

  1. Run Netwrix Auditor → Click “Reports” → Navigate to Active Directory → “Active Directory State-in-Time” → Select “User Accounts” → Click “View”.
  2. To save the file, click the "Export" button → Select Excel format → Save as → Choose a location to save it.

    Report sample:

Export Current User List in a Readable Format from Active Directory Faster

IT pros are frequently asked to export users from Active Directory into a comprehensible format.  Often they are asked to export AD users to CSV, because this structured format enables easy transformation of the data. To handle these requests in a timely manner, they need a tool that enables them to export Active Directory users to CSV in minutes.

Netwrix Auditor for Active Directory enables IT administrators to export a user list from Active Directory into an easy-to-read format. With one click, they can export AD users to Excel, so there’s no need to waste time manually crawling through data to put together a list of AD users.