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


Get mailboxes sizes in Exchange 2007

Posted on 2011-03-15
Medium Priority
Last Modified: 2012-08-14

Running Exchange 2007. I would like to get a list of mailboxes in a database and their sizes.

I can get the list of mailboxes fine, but getting their sizes is proving a bit difficult!

There is info in this article: http://www.msexchange.org/articles_tutorials/exchange-server-2007/management-administration/getting-mailbox-statistics-exchange-2007.html

Get-MailboxStatistics | Sort-Object TotalItemSize –Descending | ft DisplayName,@{ expression={$_.TotalItemSize.Value.ToKB()}},ItemCount

Problem is, I am also returned disconnected mailboxes in the DB. Does anyone know how I can get 'live' mailboxes only?
Question by:kam_uk
  • 2
LVL 13

Expert Comment

by:Felix Leven
ID: 35142352
lets see:

this shows disconnected mailboxes:
Get-MailboxStatistics -Server | where { $_.DisconnectDate -ne $null } | select DisplayName,DisconnectDate

Get-MailboxStatistics -Server | where { $_.DisconnectDate -eq $null } | select DisplayName,DisconnectDate

Author Comment

ID: 35142370

I think you misunderstood the question :) I need to find the mailbox sizes of non-disconnected mailboxes in a certain store?
LVL 13

Accepted Solution

Felix Leven earned 2000 total points
ID: 35142546
yes, and this is an example how to select the non-disconnected mailboxes^^

Get-MailboxStatistics |  where { $_.DisconnectDate -eq $null } | Sort-Object TotalItemSize –Descending | ft DisplayName,@{ expression={$_.TotalItemSize.Value.ToKB()}},ItemCount

Featured Post

Problems using Powershell and Active Directory?

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

Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
To show how to create a transport rule 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 Mail Flow >> Rules tab.:  To cr…
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 antispam), the admini…
Suggested Courses

783 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