Need Help ADQuery

This topic contains 2 replies, has 3 voices, and was last updated by  Ron 1 year, 4 months ago.

  • Author
  • #64500

    suresh krishnan

    Dear powershell Gurus 🙂

    I need to combine below results and output in to an csv file . Could some one please help.
    $groupname = "ExampleGroupname"
    $members = get-adgroupmember -identity $groupname
    $memberof = get-adprincipalgroupmembership -identity $groupname

    The result should be like

  • #64569

    Olaf Soyk

    I assume you're asking for more than just one group, right? 😉 You can do a foreach loop and create a PS custom object in this loop. Then you can pipe this to an export-csv.

  • #64579


    Unless your AD is small and fairly simple, squeezing that info into a csv can be problematic. This should help though. The member commands return objects and you are likely only interested in the samAccountname.

    $members = (get-adgroupmember -identity $groupname | select -expand samaccountname) -join "|"
    $memberof = (get-adprincipalgroupmembership -identity $groupname | select -expand samaccountname) -join "|"

    Now you can form a psobject and export to a csv file.

You must be logged in to reply to this topic.