Solved

How Can I Show Message Size in Exchange 2007 Console

Posted on 2008-10-14
5
694 Views
Last Modified: 2013-11-30
I would like to see the users mail box size without having to click on each user.
0
Comment
Question by:bryant4329
5 Comments
 
LVL 3

Accepted Solution

by:
Patricck earned 35 total points
ID: 22710743
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
 
LVL 1

Assisted Solution

by:nixgibs
nixgibs earned 60 total points
ID: 22710983
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
 
LVL 7

Assisted Solution

by:flaphead_com
flaphead_com earned 30 total points
ID: 22710993
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
 
LVL 1

Assisted Solution

by:nixgibs
nixgibs earned 60 total points
ID: 22711003
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
 

Author Comment

by:bryant4329
ID: 22825826
Good Job People
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now