• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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
0
jskfan
Asked:
jskfan
3 Solutions
 
duncanb7Commented:
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 LongTechnical ConsultantCommented:
0
 
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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
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
 
Will SzymkowskiSenior 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
 
jskfanAuthor Commented:
Excellent!!
Thank you
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now