SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[powershell] How do I get specific properties with Get-AdUser

I have the following PS script written:

Get-ADUser -Filter * -SearchBase 'OU=Users & Computers, DC=aaaaaaa, DC=com' -Properties DisplayName | Export-CSV "ADUsers.csv"

From what I can tell it should be returning only DisplayName. It's returning everything though. Problem is that DistinguishedName is causing truncation problems later on in my process. How can I get the script to only return certain properties?

This question is related to powershell active-directory powershell-2.0

The answer is

This worked for me as well:

Get-ADUser -Filter * -SearchBase "ou=OU,dc=Domain,dc=com" -Properties Enabled, CanonicalName, Displayname, Givenname, Surname, EmployeeNumber, EmailAddress, Department, StreetAddress, Title | select Enabled, CanonicalName, Displayname, GivenName, Surname, EmployeeNumber, EmailAddress, Department, Title | Export-CSV "C:\output.csv"

using select-object for example:

Get-ADUser -Filter * -SearchBase 'OU=Users & Computers, DC=aaaaaaa, DC=com' -Properties DisplayName | select -expand displayname | Export-CSV "ADUsers.csv"

Source: Stackoverflow.com

Examples related to powershell

• Why powershell does not run Angular commands? • How do I install the Nuget provider for PowerShell on a unconnected machine so I can install a nuget package from the PS command line? • How to print environment variables to the console in PowerShell? • Check if a string is not NULL or EMPTY • The term 'ng' is not recognized as the name of a cmdlet • VSCode Change Default Terminal • 'Connect-MsolService' is not recognized as the name of a cmdlet • Powershell Invoke-WebRequest Fails with SSL/TLS Secure Channel • Install-Module : The term 'Install-Module' is not recognized as the name of a cmdlet • Change directory in PowerShell

Examples related to active-directory

• Powershell: A positional parameter cannot be found that accepts argument "xxx" • How to switch to another domain and get-aduser • How can I verify if an AD account is locked? • Powershell script to see currently logged in users (domain and machine) + status (active, idle, away) • Querying Windows Active Directory server using ldapsearch from command line • How to list AD group membership for AD users using input list? • Import-Module : The specified module 'activedirectory' was not loaded because no valid module file was found in any module directory • What are CN, OU, DC in an LDAP search? • PowerShell script to return members of multiple security groups • How do I get specific properties with Get-AdUser

Examples related to powershell-2.0

• Extract the filename from a path • Out-File -append in Powershell does not produce a new line and breaks string into characters • Using PowerShell to remove lines from a text file if it contains a string • PowerShell The term is not recognized as cmdlet function script file or operable program • Can't install nuget package because of "Failed to initialize the PowerShell host" • Powershell script to see currently logged in users (domain and machine) + status (active, idle, away) • How to export data to CSV in PowerShell? • powershell is missing the terminator: " • PowerShell script to check the status of a URL • How to upgrade PowerShell version from 2.0 to 3.0