POWERSHELL / ACTIVEDIRECTORY
FreeBeginnerRead-onlylow

Export Active Directory users

Exports Active Directory user accounts to a CSV report, including identity, mail, department, job title, account status and recent logon information.

Generated locally in your browser · Review before running · Opselith does not connect to your tenant

What this PowerShell script does

Exports Active Directory user accounts to a CSV report, including identity, mail, department, job title, account status and recent logon information.

Requirements

  • CSV output path - Required. Example: C:\Temp\ad-users.csv

Environment

  • Module: ActiveDirectory
  • Permissions: Directory read access
  • Output: CSV report
  • Context: Windows PowerShell 5.1 · Active Directory RSAT
  • Risk: Low
Review before you run The script is generated locally. Test outside production first.
NEXT STEP

Ready to generate

Configure Export Active Directory users in the Builder, review the generated PowerShell and run it yourself in your own PowerShell session.

More about this script

Why use this template?

Use this free PowerShell script when you need to export active directory users. It is generated locally and can be reviewed before you run it yourself in your own PowerShell session.

The template uses ActiveDirectory and requires Directory read access. Output: CSV report. Level: Beginner. Action: Read-only. Risk: Low.

Review before running

The script is generated in your browser. Read it before you run it, and test it outside production first. “Read-only” describes the script itself; anything you add around it can still change data.

Generate the script

  1. Open the template in the PowerShell Builder.
  2. Enter the requested values and review the module, permissions, output and risk.
  3. Generate the script, read it carefully, and test it outside production before use.

The script is generated locally in your browser. Nothing needs to be uploaded to Opselith.

Generate Export Active Directory users →
Before you runModule, permissions, inputs, compatibility and script checks
OPS / SCRIPT DETAILS

Script details

Exports Active Directory user accounts to CSV. Keep the normal user report or choose only the columns you need. Review these details before generating or running the script.

active-directoryexportusersreportingidentity
Generated here. Run by you.Opselith does not connect to your tenant or run PowerShell. After generating, review the script and run it in your own PowerShell session.

What it works with

Module: ActiveDirectory

ActiveDirectory lets PowerShell work with on-premises Active Directory and is normally installed through Windows RSAT.

Context: Windows PowerShell 5.1 · Active Directory RSAT

Compatibility: Run in Windows PowerShell 5.1 on a Windows system with the ActiveDirectory module available.

Permissions and changes

Permissions: Directory read access

Risk: Low

Read-only: designed to collect information without intentionally changing the target environment.

Changes: Read-only. The script reads Active Directory user accounts and creates a CSV report. It does not change Active Directory settings or user accounts.

Inputs

  • CSV output path - Choose a new absolute Windows CSV path, for example C:\Temp\ad-users.csv. (Required)
  • Name - Optional (Optional)
  • Display name - Optional (Optional)
  • Account name (sAMAccountName) - Example: j.smith. (Optional)
  • First name - Optional (Optional)
  • Last name - Optional (Optional)
  • User principal name (UPN) - Example: john.smith@contoso.com. (Optional)
  • Email address - Optional (Optional)
  • Department - Optional (Optional)
  • Job title - Optional (Optional)
  • Account enabled - Optional (Optional)
  • Last logon date - Optional (Optional)
  • Created date - Optional (Optional)
  • Distinguished name - Optional (Optional)

What to expect

Output: CSV containing only the Active Directory user columns you select.

Expect a CSV file at the path you choose. Open it in Excel or another CSV viewer and review the rows.

Example: C:\Temp\report.csv

This template is in the Free library and is generated locally in your browser. Opselith does not run it; you review and run the script in your own PowerShell session.

Example use

Exports Active Directory user accounts to CSV. Keep the normal user report or choose only the columns you need.

Enter the required values in the Builder, review the generated script and confirm the output before running it.

Before you run: Use a Windows account that can read Active Directory users. Make sure the ActiveDirectory module is available through Windows RSAT, choose a new CSV output path and review the generated script before running it.
Script checksWhat has been verifiedQA reviewed
Static checksPassed
PSScriptAnalyzerPending
Real-world run testNot yet recorded
Last checkedNot yet recorded

Real-world run results are shown only after Opselith reviews and accepts a tester report.

Tester: report a result →
TEST STATUSWhat Opselith has checked

Last reviewed: 3 Sept 2026

PSScriptAnalyzer: Awaiting a release PSScriptAnalyzer gate that includes this script. No analyzer pass is claimed yet.

Pending or Not yet recorded means there is no accepted result on file yet. A passed analyzer check does not mean the script has been run in a real tenant.

AFTER YOU RUN IT

Review the exported users locally

Once PowerShell creates the CSV, open it in Directory User Review to check user identities, email values, sign-in domains and account status. The CSV stays in your browser.