Description:
We can easily export Active Directory users to CSV file using Powershell cmdlets Get-ADUser and Export-CSV. In this article, I am going to write Powershell script samples to Export AD Users to CSV file and Export AD Users from Specific OU to CSV file using Powershell Script.
Summary:
Export AD Users to CSV using Powershell
The following command export the selected properties of all Active Directory users to CSV file. You can add more attributes as per your wish, refer this article:Get-ADUser Default and Extended Properties to know more supported AD attributes.
Import-Module ActiveDirectory Get-ADUser -Filter * -Properties * | Select -Property Name,Mail,Department | Export-CSV "C:\AllADUsers.csv" -NoTypeInformation -Encoding UTF8
Export AD Users to CSV with Filter using Powershell
This command export the selected properties to CSV file of AD users whose City contains the text ‘Austin’.
Note: Refer this article:Get-ADUser Default and Extended Properties to know more supported AD attributes.
Import-Module ActiveDirectory Get-ADUser -Filter 'City -like "*Austin*"' -Properties * | Select -Property Name,City,Mail,Department,DistinguishedName | Export-CSV "C:\ADUsers.csv" -NoTypeInformation -Encoding UTF8
Export AD Users by LDAP Filter:
Instead of SQL Like Filter, you can also use LDAP Filter to select only required users. Refer this article (AD LDAP Filter Examples) to get more LDAP filter examples. The below command exports all the users who are belongs to Admin department.
Import-Module ActiveDirectory Get-ADUser -LDAPFilter '(Department=*Admin*)' -Properties * | Select -Property Name,City,Mail,Department,DistinguishedName | Export-CSV "C:\AdminUsers.csv" -NoTypeInformation -Encoding UTF8
Export ADUsers CSV output:
Export AD Users from specific OU to CSV using Powershell
We can set target OU scope by using the parameter SearchBase. This following command select all the AD users from the Organization Unit ‘Austin’ and export it to CSV file.
Import-Module ActiveDirectory Get-ADUser -Filter * -SearchBase "OU=Austin,DC=TestDomain,DC=Local" -Properties * | Select -Property Name,Mail,Department | Export-CSV "C:\AustinUsers.csv" -NoTypeInformation -Encoding UTF8
Thanks,
Morgan
Software Developer
Hi Morgan,
How can I schedule a task that export AD users to CSV using Powershell? Thanks.
Hi 名家幼稚園, I have written new article for you. checkout this: https://www.morgantechspace.com/2014/11/Schedule-Task-to-Export-AD-Users-to-CSV-using-Powershell.html
HI Morgan,
Thank you very much. I am a newbie for the Powershell. Your articles are very helpful to me.
Hi Morgan, your article is simple and very powerfull. I am still beginner, but you help me much. Thank you Jiri
Hi Morgan,
I tried Export AD Users from specific OU to CSV using Powershell in my client laptop, but unfortunately i recieved Invalid Enumeration Context Error and created CSV partially with only 256 items.
Do you have any fixsuggestion for the issue i am facing? Awaiting your response.
Thanks,
Praveen