Get mailboxes sizes in Exchange 2007

Hi

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?
LVL 3
kam_ukAsked:
Who is Participating?
 
Felix LevenSenior System and DatabaseadministratorCommented:
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
0
 
Felix LevenSenior System and DatabaseadministratorCommented:
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
0
 
kam_ukAuthor Commented:
Hi

I think you misunderstood the question :) I need to find the mailbox sizes of non-disconnected mailboxes in a certain store?
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.

All Courses

From novice to tech pro — start learning today.