Allow duplicate values in 2 dimensional array in PowerShell

Question

Im trying to generate a report of mailbox permissions out of Exchange Online. Here is the code:

$SendAs = @()
$Mailboxes = Get-mailbox | where {$_.Identity -notlike "DiscoverySearchMailbox*"}

Foreach ($MB in $Mailboxes) {
    $SendAsTemp = Get-RecipientPermission $MB.userprincipalname | select identity,Trustee,AccessRights | `
        Where-Object {$_.Trustee -notlike "*\Self" -and $_.Trustee -notlike "S-1-5*"}
    if ($SendAsTemp) {
        $SendAs += New-Object psobject -Property @{
            Identity=$SendAsTemp.identity
            Mailbox=$MB.primarysmtpaddress
            Trustee=$SendAsTemp.Trustee
            AccessRights=$SendAsTemp.AccessRights
        }
    }
}

The problem is that the output ($SendAs) is this;

Mailbox              Trustee                                 AccessRights           Identity
[email protected]    {[email protected], [email protected]}    {SendAs, SendAs}       {shared, shared}

Its adding the multiple trustee permissions of 'shared' to a single row. What I want is this;

Mailbox              Trustee                                 AccessRights           Identity
[email protected]    [email protected]                        SendAs                 shared
[email protected]    [email protected]                        SendAs                 shared

How do I achieve this?

score 0 · Answer 1 · answered Aug 11 '20 at 06:54

First of all, avoid using the increase assignment operator (+=) to create a collection as it is exponential expensive. Meaning, it gets more expensive with every iteration. Use the PowerShell pipeline instead.

For your specific issue you can simply iterate through the trustees, like:

$Mailboxes = Get-mailbox | where {$_.Identity -notlike "DiscoverySearchMailbox*"}

$SendAs = Foreach ($MB in $Mailboxes) {
    $SendAsTemp = Get-RecipientPermission $MB.userprincipalname | select identity,Trustee,AccessRights |
        Where-Object { $_.Trustee -notlike "*\Self" -and $_.Trustee -notlike "S-1-5*" }
    if ($SendAsTemp) {
        Foreach ($Trustee in @($SendAsTemp.Trustee)) {
            New-Object psobject -Property @{
                Identity = $SendAsTemp.identity
                Mailbox = $MB.primarysmtpaddress
                Trustee = $Trustee
                AccessRights = $SendAsTemp.AccessRights
            }
        }
    }
}

_{(Note that in this example whole mailbox entry will not be listed if it doesn't have any trustees at all.)}

Thanks that works kinda, however now the accessrights and identity have multiple values. For example if there is 2 trustees, then in each row the accessrights field has '{SendAs, SendAs}'. Thanks for info re += performance issues. — Kav, Aug 12 '20 at 06:56

Allow duplicate values in 2 dimensional array in PowerShell

1 Answers1