Export AD Users to csv file

Question

Hi Experts

i have a OU i want to pull all the users in that OU to csv file, can anyone help me with the syntax. i want to try the below syntax will it work

Get-ADUser -Filter * -SearchBase "OU=MYOU,OU=TopLevelOU,DC=contoso,DC=com" -Properties * | Select-Object Displayname,Description,userprincipalname,samaccountname,LastLogin | Export-csv C:\output.csv -NoTypeInformation

Answer 1

The below PowerShell command should work

Get-ADUser -Filter * -SearchBase "OU=Research,OU=Users,DC=ad,DC=contoso,DC=com" -Properties * | Select-Object name | export-csv -path c:\temp\userexport.csv  

You can also do the same task using AD GUI

• Open AD, Click on Filter Button.

• Perform a Custom filter for Organization Unit.

• Click on the Export button

• Select CSV file extension

Answer 2

Hi @Roger Roger

Something like this:

If you have a big AD, that might take a while though.

Import-Module ActiveDirectory
Get-ADUser -Filter * -Properties * | export-csv c:\ADusers.csv

Export users from Active Directory using PowerShell
There is another, much quicker way to accomplish the title task. You can export users from Active Directory using PowerShell. The cmdlet below exports a complete list of my company’s users to a csv file.

Get-ADUser -Filter 'Company -like "Alpha*"' -Properties * | Select -Property EmailAddress,GivenName,Surname,DisplayName,Title,Department,Office,OfficePhone,MobilePhone,Fax,StreetAddress,City,State,PostalCode,Country | Export-CSV "C:\\ADusers.csv" -NoTypeInformation -Encoding UTF8

Powershell Script to export Active Directory users to CSV

Please don’t forget to Accept the answer and up-vote wherever the information provided helps you, this can be beneficial to other community members.

Answer 3

Use the below PowerShell CMD and collect the users and computers dump details.

Import AD module (if not already loaded)

Import-Module ActiveDirectory

Export AD Users

Get-ADUser -Filter * -Properties SamAccountName, DisplayName, UserPrincipalName, Enabled, LastLogonDate, DistinguishedName, EmailAddress `

| Select-Object SamAccountName, DisplayName, UserPrincipalName, Enabled, LastLogonDate, DistinguishedName, EmailAddress `

| Export-Csv "C:\AD_Users_Dump.csv" -NoTypeInformation -Encoding UTF8

Export AD Computers

Get-ADComputer -Filter * -Properties Name, DNSHostName, IPv4Address, OperatingSystem, Enabled, LastLogonDate, DistinguishedName `

| Select-Object Name, DNSHostName, IPv4Address, OperatingSystem, Enabled, LastLogonDate, DistinguishedName `

| Export-Csv "C:\AD_Computers_Dump.csv" -NoTypeInformation -Encoding UTF8