Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 717
  • Last Modified:

How Can I Show Message Size in Exchange 2007 Console

I would like to see the users mail box size without having to click on each user.
0
bryant4329
Asked:
bryant4329
4 Solutions
 
PatricckCommented:
Its no longer available in the GUI.
Get-MailboxStatistics
http://technet.microsoft.com/en-us/library/bb124612(EXCHG.80).aspx 
You can filter the mailboxes in a number of ways :
- Get-MailboxStatistics -Server "MYSERVER1"
- Get-MailboxStatistics -Database "Database DN"

Or:
You can pipe the results into a file and then open that in excel - this
thread explains how to go about this:
http://forums.msexchange.org/m_1800455592/tm.htm

Or:
http://gsexdev.blogspot.com/2008/05/version-5-of-mailbox-size-gui-script.html
0
 
nixgibsCommented:
Hi

you can use the following command in the exchange shell

it shows you the mailbox size in MB and KB sort by the size and displays an additional information of the deleted item size of each mailbox.

I hope this helps you
Get-MailboxStatistics | sort totalitemsize | ft displayname, itemcount, @{ expression={$_.TotalItemSize.Value.ToKB()};label="Postfach in KB" }, @{ expression={$_.totaldeleteditemsize.value.tokb()};label="Gelöschte in KB" }, @{ expression={$_.totalitemsize.value.tomb()};label="Postfach in MB" }

Open in new window

0
 
flaphead_comCommented:
I run two scripts:
1) will export all the users mailbox stats to a csv file.  I run this once a week
2) I use to get my top 10 biggest mailboxes.  Again I run this once week
1)
Get-MailboxServer | Get-MailboxStatistics | Export-csv MailboxStatistics.csv
 
2)
$Top10 = Get-MailboxServer | Get-MailboxStatistics | Sort TotalItemSize -Descending; for ($i=0;$i-le9;$i++){$xtxt = $top10[$i].DisplayName;$xtxt+= "";$xtxt += $top10[$i].totalitemsize;Write-Host $xtxt}

Open in new window

0
 
nixgibsCommented:
Sorry here the english version of the script
Get-MailboxStatistics | sort totalitemsize | ft displayname, itemcount, @{ expression={$_.TotalItemSize.Value.ToKB()};label="Mailbox in KB" }, @{ expression={$_.totaldeleteditemsize.value.tokb()};label="Deleteditems in KB" }, @{ expression={$_.totalitemsize.value.tomb()};label="Mailbox in MB" }

Open in new window

0
 
bryant4329Author Commented:
Good Job People
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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