1

In exchange 2010, how can I sort the mailboxes by size to talk to certain users about deleting their deleted folders? How do you guys go about telling a user to keep their mailbox cleaned up?

2 Spice ups
2

We have Exchange 2007 and I use the Spiceworks Exchange Health widget as a quick and easy way to see mailbox sizes. I would guess this also works with 2010, but I don’t know for sure.

3

Easiest way would be to export them to a text file, then open in Excel and sort the Item column.

Open the command shell and use the following command.

Get-MailboxSatistics -database ‘name of DB you want the mailboxes from goes here’ >> C:\mailbox_results.txt

That will create a text file in the root of C with the statistics of every mailbox on the database you specify. Now simply open that in Excel and sort the column. You could even script this as a scheduled task to stay on top of it say monthly, email into SW and it would create a ticket for you.

-Jay

4

Thanks guys! Didn’t think about the widget. Jay, your way is great but I will just look at the widget easier to do from day to day.

5

Ooooo…I found an even better one, since the above just gives a mail count and not the size. This one you can keep in the shell or export to txt file and then open in Excel.

Get-MailboxDatabase ‘name of DB’ | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalsize, itemcount

If you want to export it add >> and the path with file name to the end of that.

-Jay

6

http://www.msexchange.org/articles_tutorials/exchange-server-2007/management-administration/getting-mailbox-statistics-exchange-2007.html

7

I’ve been using the method Jay6111 suggested. It’s kind of a pain and I miss the widget functionality that I had when I was still using Exchange 2003. I’ve seen the script that will export the information to Spiceworks, but “as is,” the script only allows you to select one mailbox and outside of batch files, I’m no expert on scripts to modify it to send all of my users’ mailboxes to Spiceworks.

8

afeitguy wrote:

I’ve been using the method Jay6111 suggested. It’s kind of a pain and I miss the widget functionality that I had when I was still using Exchange 2003. I’ve seen the script that will export the information to Spiceworks, but “as is,” the script only allows you to select one mailbox and outside of batch files, I’m no expert on scripts to modify it to send all of my users’ mailboxes to Spiceworks.

I think that you ened to specify the server. I had the same problem until I specified the server.

.\push.ps1 your_spice_server.domain.com –exchangeServer your exchange server

-Jay

9

Jay6111 wrote:

You are the man! You don’t know how many hours I spent playing with that. I really need to learn these newer command line utilities.

10

Don’t feel bad, I knew VB, then batch, then Cisco, then HP, and now powershell and they are all starting to get messed together. BAH!

-Jay