Powershell Help - Add Active Directory MemberOf to existing Script

The working PowerShell script below provides me with all the users from a specific AD Group. It also lists their Title and Department. I want to add another column that lists all of the other AD Groups they are a member of. I added an example, the first 3 columns are from the working script the last column in yellow is what I would like to see. I appreciate the help, my PowerShell expertise is limited.

$identity = 'TestGroup'
$Server = 'Test.Local'
Get-ADGroupMember –identity $identity -Server $Server -Recursive | 
Get-ADUser –Server $Server -Property Name, Title, Department | Select Name, Title, Department |
Get-ADPrincipalGroupMembership | select name, groupscope | Export-CSV –path C:\Temp\Test15.csv –NoTypeInformation

End Result Example

Don't pipe over to Get-ADPrincipalGroupMembership and use a calculated property putting the cmdlet within the expression part of the object.

Values are created as arrays so use foreach-object along with PowerShell $( ) operators to turn the "group name" and "scope" into colon separated values (i.e. <group name>:<group scope>).

Furthermore, join all the colon separated value pairs with a semicolon (";") to concatenate all group names and group scope object pairs into one csv field.

Since this is csv data, you probably shouldn't separate any concatenated grouped pair values with a comma or import processes may interpret wrong.

Field Output Example

groupa:global;groupb;domainlocal;groupc:domainlocal

Csv Output Example

"Name","Title","Department","MemberOfPrimaryGroups"
"Administrator",,,"GroupA:DomainLocal;GroupB:DomainLocal;KoolAdmins:Global"
"John Doe","Systems Administrator","IT"," GroupA:DomainLocal;GroupB:DomainLocal;KoolAdmins:Global"
"Curly Moe","IT Manager","IT","GroupA:DomainLocal;GroupB:DomainLocal;KoolAdmins:Global"

PowerShell

$identity = 'TestGroup'
$Server = 'Test.Local'

Get-ADGroupMember -Identity $identity -Server $Server -Recursive  | 
    Get-ADUser –Server $Server -Property Name, Title, Department | 
        Select-Object Name, Title, Department, @{
            N="MemberOfPrimaryGroups";
            E={(Get-ADPrincipalGroupMembership $identity | ForEach-Object {
                "$($_.Name):$($_.GroupScope)" }) -join ";"}} | 
                    Export-CSV –path C:\Temp\Test15.csv –NoTypeInformation;

Supporting Resources

• Calculated_Properties
• Add a calculated property with Select-Object in PowerShell
• ForEach-Object
• PowerShell Operators $( ) @( ) :: &
• -Join operator