Author Posts

January 14, 2017 at 6:45 pm

Hello,

I want to search AD using the displayprintablename due to our tracking system. I can export a CSV to include their full name, POBox, ticket number. I have to use ANR and the problem with that is if I have 50 John Doe's I need to filter based on their POBox.

I want to run this report everyday so if a person is no longer in AD, we can close their ticket. I have this code and it works perfectly, I *think* I just need to add another -and statement but my brain can't come up with the solution

$arraylist = Import-Csv '\\nw145757\Projects\QuerySnow.csv'
$arraylist | % {
Get-ADUser -filter "anr -eq '$($_.RequestedFor)'" -Properties * | select displaynamePrintable, DisplayName, POBox, samAccountName, mail
} | ft

Cheers!

January 14, 2017 at 6:53 pm

"anr -eq '$($_.RequestedFor)' -and something -eq something"

?

January 14, 2017 at 10:46 pm

that was it. I'm not sure how I missed this but I appreciate it!

January 17, 2017 at 10:12 pm

It's not but I have a feeling I know who that is