Author Posts

February 17, 2017 at 3:59 am

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

February 17, 2017 at 3:15 pm

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.

February 17, 2017 at 3:35 pm

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.