Export User Information to CSV

This script exports detailed information for all users in a specific OU to a CSV file. It’s useful for reporting and audits.

# Define the OU and output file path
$ou = "OU=YourOU,DC=YourDomain,DC=com"
$outputFile = "C:\Path\To\AD_Users_Report.csv"

# Export user details
Get-ADUser -Filter * -SearchBase $ou -Properties DisplayName, SamAccountName, EmailAddress, LastLogonDate |
    Select-Object DisplayName, SamAccountName, EmailAddress, LastLogonDate |
    Export-Csv -Path $outputFile -NoTypeInformation -Encoding UTF8

Write-Output "User information exported to $outputFile"

• Explanation: This script exports users from a specified OU, including details like display name, username, email, and last logon, to a CSV file.

Last updated