Get-Aduser -filter

This topic contains 4 replies, has 3 voices, and was last updated by Profile photo of PowerShell PowerShell 4 months, 1 week ago.

  • Author
    Posts
  • #61929
    Profile photo of PowerShell
    PowerShell
    Participant

    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!

  • #61930
    Profile photo of Don Jones
    Don Jones
    Keymaster

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

    ?

    • #61965
      Profile photo of PowerShell
      PowerShell
      Participant

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

  • #62035
    Profile photo of Dan Potter
    Dan Potter
    Participant
  • #62061
    Profile photo of PowerShell
    PowerShell
    Participant

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

You must be logged in to reply to this topic.