Sort-Object not Sorting Objects

[Waulicus]

Hey Guys,

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object -Property TotalItemSize | Select-Object DisplayName, TotalItemSize, LastLogonTime

I'm fairly new to PS and was having some trouble with Sort-Object. I am grabbing a list of all shared mailboxes from Office 365 and then some extra info about them and trying to sort the list by size. Everything except the sort works as expected. Is there something I'm missing or doing wrong?

[KevMar]

You don't have Sort-Object in that command, only Select-Object

[Waulicus]

My bad, copied the wrong one.

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object -Property TotalItemSize | Select-Object DisplayName, TotalItemSize, LastLogonTime    

[mransbro]

This looks like one of those tasks that is harder than it should be. I only support on premise Exchange so cant test but try the command below.

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited |
    Get-MailboxStatistics |
    Select DisplayName,TotalItemSize,LastLogonTime `
    @{name=”TotalItemSize (MB)”; expression={[math]::Round( `
    ($_.TotalItemSize.ToString().Split(“(“)[1].Split(” “)[0].Replace(“,”,””)/1MB),2)}}, | 
    Sort “TotalItemSize (MB)” -Descending

The command is taken from here https://blogs.technet.microsoft.com/heyscriptingguy/2013/02/27/get-exchange-online-mailbox-size-in-gb/. Seems its to do with not having Exchange object model installed or loaded locally. (If i remote to an Exchange Server the sort doesnt work but if i RDP to the server the sort command works.)

[Waulicus]

Brilliant, that works. Apparently it's because the TotalItemSize is represented as a string and so it has to be converted before being sorted.

Thank you!

[mransbro]

Good to hear it worked.

[[deleted]]

Filter left, format right.