PowerShell GUI - Listview with top 30 mailboxes

Question

Hello everybody! Need some help - trying to create PowerShell script to show top30 mailboxes (depends of size):

$listMailboxesSize=Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,TotalItemSize -First 30


foreach ($item in $listMailboxesSize)
{
   $i = New-Object System.Windows.Forms.ListViewItem($item.DisplayName)
   $i.SubItems.Add([string]$item.TotalItemSize)
   $listView.Items.Add($i) | Out-Null

}

$frmMain.Controls.Add($listView)

It works but there is no ordering by size in this example. What should I add in this code to make it possible? Thank you.

Answer 1

Are these mailboxes in your on-premises organization or Office 365?

If they're O365 mailboxes, try this:

Get-MailboxStatistics | 
    Select-Object DisplayName, @{Name="TotalItemSizeMB"; Expression={[math]::Round(($_.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1MB),0)}} |
        Sort-Object TotalItemSizeMB

Answer 2

you can also try Exchange Reporter (script is in english)

https://www.frankysweb.de/exchange-reporter-2013/

Answer 3

Here is a little investigation - I run all the same script using PS and using my GUI so the difference you can see on screens below. Looks like the problem is with a variable $listMailboxesSize. It already takes value as a list without ordering. How can it be?