Need Help ADQuery

Dear powershell Gurus :slight_smile:

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
Domainname,members,Memberof

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

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.