Select-Object returns the first result as my column name instead of as a result

Question

The following script checks mailboxes in a specified OU for users with the default permission set to Owner. I have tried everything to add the column "Name" from the variable $Mailbox to the Select-Object results in the following code. The result will add a column header with the first results name as the header. If there are multiple results the first name found will be the column header with the column blank for the others. Is there a way to add the "Name" column from the variable $Mailbox to the Select-Object results?

$AllMailBox = Get-Mailbox   -OrganizationalUnit "XXXXXXXXXX.com/DomainUsers/Users" -resultsize unlimited
ForEach ($MailBox in $AllMailbox) {Get-mailboxfolderpermission $Mailbox | Where-object {$_.User -match "Default" -AND $_.AccessRights -match "Owner"} | Select-Object  Identity, AccessRights, $MailBox.Name} 

Answer 1

Instead of

Select-Object  Identity, AccessRights, $MailBox.Name} 

Add this

Select-Object  Identity, AccessRights, @{l="Name";e={$MailBox.Name}}} 

where l stands for Label and e stands for Expression.

You can read more about custom tables here https://technet.microsoft.com/en-us/library/ee692794.aspx?f=255&MSPPError=-2147217396

Answer 2

$MailBox.Name lives in outer scope. It isn't a valid property of item returned from Get-mailboxfolderpermission.

You can use calculated property in Select-Object to add additional data to the result:

{Get-mailboxfolderpermission $Mailbox | Where-object {$_.User -match "Default" -AND $_.AccessRights -match "Owner"} | Select-Object  Identity, AccessRights,@{Name="Name"; Expression={$MailBox.Name}}

Calculated property is declared by hash table with keys:

• Name — the name of the property
• Expression — script block that returns a value

See "EXAMPLE 4" here for another example of calculated property.