display all mailboxes by size

I am looking for a powershell command that will display all mailboxes in all servers databases and sort them by size, from the larger size to smaller size.

I know that this can be done by dumping the output to Excel file then using Excel to sort them put.

I wonder if there is powershell combination command that can achieve the same thing.

Thank you
jskfanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Will SzymkowskiConnect With a Mentor Senior Solution ArchitectCommented:
Yes... Use the following command below...

get-mailbox -ResultSize "unlimited" | Get-MailboxStatistics | sort -Property TotalItemSize | se
lect Displayname, TotalItemSize, TotalDeletedItemSize | out-file "c:\mailboxstats.txt"

Will.
0
 
duncanb7Connect With a Mentor Commented:
Did you read those related articles before  that might help on your issue ?

http://exchangeserverpro.com/powershell-tip-get-list-top-exchange-server-mailboxes-size/
http://www.petri.co.il/create-exchange-2010-mailbox-size-reports-powershell.htm


Hope understand your question completely, if not please point it out

Duncan
0
 
Pete LongConnect With a Mentor Technical ConsultantCommented:
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Will SzymkowskiSenior Solution ArchitectCommented:
Use the following command below to accomplish this...

get-mailbox -ResultSize "unlimited" | Get-MailboxStatistics | sort -Property TotalItemSize | se
lect Displayname, TotalItemSize, TotalDeletedItemSize

Open in new window


Will.
0
 
jskfanAuthor Commented:
get-mailbox -ResultSize "unlimited" | Get-MailboxStatistics | sort -Property TotalItemSize | se
lect Displayname, TotalItemSize, TotalDeletedItemSize


This worked...is there a switch to add to dump the output into a text file ?

Thank you
0
 
jskfanAuthor Commented:
Excellent!!
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.