Solved

How Can I Show Message Size in Exchange 2007 Console

Posted on 2008-10-14
5
691 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

744 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

9 Experts available now in Live!

Get 1:1 Help Now