get-aduser using emailaddress

powershell filter active-directory email-address
Hans Torres picture Hans Torres · Dec 19, 2017 · Viewed 16.6k times · Source

when i want to get some information from an user i use this:

Get-ADUser -Filter {EmailAddress -eq '[email protected]'}

but when i wanna check the information from a bulk of users i try this:

$batch| foreach {Get-ADUser -Filter {emailaddress -eq $_.email}}

email is the name of the variable in the CSV file but i am getting this error:

"Get-ADUser : Property: 'email' not found in object of type: 'System.Management.Automation.PSCustomObject'"

i can not use the identity because te emailaddess is not supported for this one

Answer

rzantarra picture rzantarra · Dec 19, 2017

It doesn't look like you are setting up properties for the search result to return. Ie: 

Import-csv -Path \\tsclient\c\temp\test.csv -delimiter ";" | ForEach {
Get-ADUser -Filter "EmailAddress -eq '$($_.email)'" -Properties EmailAddress 
}

Related questions

How to properly -filter multiple strings in a PowerShell copy script

I am using the PowerShell script from this answer to do a file copy. The problem arises when I want to include multiple file types using the filter. Get-ChildItem $originalPath -filter "*.htm" | ` foreach{ $targetFile = $htmPath + $_.FullName.SubString($originalPath.Length); ` New-Item …

Read More
Powershell Get-ChildItem -Filter operates differently to Where clause with same value

I have a folder on a server called MyFolder. There are additional folders called MyFolder.1, MyFolder.2, MyFolder.3 etc. If I run: gci C:\Sample | ? { $_.Name -like "MyFolder.*" } I get the expected output: Directory: C:\Sample Mode LastWriteTime Length Name ---- …

Read More
Setting GPO security filter with powershell Set-GPPermissions cmdlet

According to Microsoft the cmdlet Set-GPPermissions accepts the option "-replace": "This ensures that the existing permission level is replaced by the new permission level." I import a GPO from PowerShell. After that I want to set the security filters. After …

Read More