Format an array inside powershell object

Question

So I have a script that grabs each user and all groups the user belongs in. When I export to a CSV, it has the user in one column, and in the next, all the groups the user is in. Is there anyway to make it where the groups can have their own line each, as opposed to all groups in one cell? This is how the output looks

[user][usergroup a, usergroupb, etc]

and I want

[user][usergroupa]

[ ][usergroupb]

This is my code if anyone wants it:

$users = get-azureaduser -Top 400 | Where-Object{$_.jobtitle -ne $null} |Where-Object{$_.department -eq "Information Technology"} | select userprincipalname
$groups = ForEach($user in $users){
$usergroups = get-azureadusermembership -ObjectId $user.UserPrincipalName | select displayname 

New-Object -TypeName PSObject -Property @{
            User=$user.UserPrincipalName
            Groups = [string]$usergroups.displayname
}
}
$groups | Export-Csv -Path 'C:\TEXTDUMP\usergroups.csv'

Do you mean Groups = $usergroups.displayname -join [environment]::NewLine ? — Theo
– Theo, Commented Jan 12, 2023 at 15:56
The csv should have all groups each on a separate line. If you look at this in Excel, you need to have the cells expand vertically to see the rest — Theo
– Theo, Commented Jan 12, 2023 at 16:02

Mathias R. Jessen · Accepted Answer · 2023-01-12 16:03:29Z

1

You just need an extra foreach loop over the group memberhips:

$users = Get-AzureADuser -Top 400 | Where-Object { $_.jobtitle -ne $null } | Where-Object { $_.department -eq "Information Technology" } | Select-Object -ExpandProperty userprincipalname
$groupMemberships = ForEach ($user in $users) {
    $userGroups = Get-AzureADUserMembership -ObjectId $user | Select-Object -ExpandProperty displayName

    foreach($group in $userGroups){
        New-Object -TypeName PSObject -Property @{
            User   = $user
            Group  = $group
        }
    }
}

$groupMemberships | Export-Csv -Path 'C:\TEXTDUMP\usergroups.csv'

This will produce 1 CSV row per membership, rather than per user

answered Jan 12, 2023 at 16:03

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Santiago Squarzon · Accepted Answer · 2023-01-12 16:22:58Z

1

I believe you're looking to expand the data per group, each group per line. If so, you need to loop over the result from Get-AzureADUserMembership:

Get-AzureADUser -Filter "department eq 'Information Technology'" -Top 400 | ForEach-Object {
    if($_.jobTitle) {
        foreach($group in Get-AzureADUserMembership -ObjectId $_.UserPrincipalName) {
            [pscustomobject]@{
                User   = $_.UserPrincipalName
                Groups = $group.DisplayName
            }
        }
    }
} | Export-Csv -Path 'C:\TEXTDUMP\usergroups.csv'

Haven't used the AzureAD Module in a while but I believe the filter:

-Filter "department eq 'Information Technology'"

Should work and be a good replacement for:

Where-Object { $_.department -eq "Information Technology" }

edited Jan 12, 2023 at 16:22

answered Jan 12, 2023 at 16:03

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

2 Comments

lakerskill Over a year ago

The -Filter part didn't work, but you did produce the results needed with the rest so THANK YOU

Santiago Squarzon Over a year ago

@lakerskill got an invalid filter clause?

Collectives™ on Stack Overflow

Format an array inside powershell object

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related