Get-ADUser Filter error when adding a string criteria containing a variable

Question

I am trying to get only active AD Users in AD which satisfies below conditions:

samaccountname is not null
mail is not null
mail ends with a domain, in this case what is contained in @oldDomain variable

As a demo, I have also filter by only a samaccountname. Below is not working:

$Users = Get-ADUser -Filter {(samaccountname -ne "null") -and (samaccountname -eq "TestUserPruebasSI") -and (Enabled -eq "true") -and (mail -ne "null") -and "mail -like '*$oldDomain'"}

The culprit is the last criteria "mail -like '*$oldDomain'". If I remove it then query Get-ADUser works.

So how can I solve this?

"mail -like '*$oldDomain'" -> mail -like "*$oldDomain"

Ansgar Wiechers
– Ansgar Wiechers

2019-04-26 09:50:02 +00:00
Commented Apr 26, 2019 at 9:50 — Ansgar Wiechers
– Ansgar Wiechers, Commented Apr 26, 2019 at 9:50

Willy · Accepted Answer · 2019-04-26 09:57:18Z

1

Using below works:

$Users = Get-ADUser -Filter "samaccountname -ne 'null' -and samaccountname -eq 'TestUserPruebasSI' -and Enabled -eq 'true' -and mail -ne 'null' -and mail -like '*$oldDomain'"

answered Apr 26, 2019 at 9:57

Willy

10.8k31 gold badges173 silver badges350 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Theo Over a year ago

You can safely skip the samaccountname -ne 'null' and mail -ne 'null' parts, because later on you filter on these properties to have a value to compare against. Besides.. is it possible for a user to NOT have a SamAccountName ??

Collectives™ on Stack Overflow

Get-ADUser Filter error when adding a string criteria containing a variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related