ProxyAddress

miriampabon1732 · 2022-08-08T13:06:16.000Z

This one liner works like a charm:

Get-ADUser -Filter { proxyAddresses -like “Sonia.Karnawat@TN.123.org”} -Properties SamAccountName, EmailAddress, enabled | Select samAccountName, emailaddress, enabled

Need to read multiple proxyAddresses from csv file, but this is not working:

cls
Import-Module ActiveDirectory
$count = 0
$UserId = Import-Csv c:\temp\EMail.csv

ForEach($Item in $UserId)
{

Get-ADUser -Filter { proxyAddresses -like “$item.email”} -Properties SamAccountName, EmailAddress, enabled | `
Select samAccountName, emailaddress, enabled

}

Here’s the csv file Email.csv

Email
Sonia.Karnawat@tn.123.org
Aayush.Mahipal@fl.123.org
AMarcy@123.org

Neally · 2022-08-08T14:00:25.000Z

Many ways to solve this, you need a dynamic way to update your filter.

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Evan7191 · 2022-08-08T14:08:28.000Z

In my experience, if you want to use the -like operator with a variable and wildcards, you should use quotation marks for -Filter instead of curly braces. For example:

Get-ADUser -Filter "proxyAddresses -like '*$($item.email)*'" -Properties SamAccountName, EmailAddress, enabled | 
    Select samAccountName, emailaddress, enabled

I usually prefer to use curly braces in filters, but quotation marks work better for this case.

Also, you don’t need to use the backtick ` after a pipeline character.

miriampabon1732 · 2022-08-08T16:56:24.000Z

Thank you!

Evan7191:

In my experience, if you want to use the -like operator with a variable and wildcards, you should use quotation marks for -Filter instead of curly braces. For example:
Get-ADUser -Filter "proxyAddresses -like '*$($item.email)*'" -Properties SamAccountName, EmailAddress, enabled | 
    Select samAccountName, emailaddress, enabled
I usually prefer to use curly braces in filters, but quotation marks work better for this case.

Also, you don’t need to use the backtick ` after a pipeline character.