Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

display all mailboxes by size

Posted on 2013-11-29
6
Medium Priority
?
278 Views
Last Modified: 2013-12-03
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
Comment
Question by:jskfan
6 Comments
 
LVL 13

Assisted Solution

by:duncanb7
duncanb7 earned 200 total points
ID: 39686398
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
 
LVL 57

Assisted Solution

by:Pete Long
Pete Long earned 200 total points
ID: 39686782
0
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39688058
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:jskfan
ID: 39691401
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
 
LVL 53

Accepted Solution

by:
Will Szymkowski earned 1600 total points
ID: 39691404
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
 

Author Closing Comment

by:jskfan
ID: 39693612
Excellent!!
Thank you
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
how to add IIS SMTP to handle application/Scanner relays into office 365.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question