Powershell DisplayName+TotalItemSize+CustomAttribute

[guest]

I would like to combine the results of get-mailboxstatistics with TotalItemSize.Value to GB, and get-mailbox with CustomAttribute.

Get-mailbox -resultsize unlimited | where {$_.CustomAttribute1 -eq "attribute name"} | Select display

Get-MailboxStatistics | select-object DisplayName, {$_.TotalItemSize.Value.ToGB()}

[guest]

According to your problem description, I understand that you would like to combine the results of get-mailboxstatistics and get-mailbox cmdlets. If my understanding is not correct, please feel free to let me know.



Based on my knowledge, please try to run the following cmdlet to check whether this objective can be achieved.



Please run this cmdlet first:

$Mailboxes = Get-mailbox -resultsize unlimited | where {$_.CustomAttribute1 -eq "attribute name"} | Select display



Then run this cmdlet:



$Mailboxes | Get-MailboxStatistics | select-object DisplayName, {$_.TotalItemSize.Value.ToGB()}



After that, please check whether the cmdlet can be performed and let me know the results.