Solved

managing exch 2010 bd sizes

Posted on 2012-03-15
4
344 Views
Last Modified: 2012-03-15
How can I report on the size of ex2010 DBs, how many users are in each DB, size of their mailboxes etc?
0
Comment
Question by:DEFclub
4 Comments
 
LVL 19

Assisted Solution

by:R--R
R--R earned 167 total points
Comment Utility
0
 
LVL 7

Assisted Solution

by:ingetic
ingetic earned 166 total points
Comment Utility
from : http://www.mikepfeiffer.net/2010/03/exchange-2010-database-statistics-with-powershell/

Total database size
Total number of mailboxes per database
Average mailbox size
Date and time of the last full backup
Amount of white space in the database

function Get-DatabaseStatistics {
    $Databases = Get-MailboxDatabase -Status
    foreach($Database in $Databases) {
        $DBSize = $Database.DatabaseSize
        $MBCount = @(Get-MailboxStatistics -Database $Database.Name).Count

        $MBAvg = Get-MailboxStatistics -Database $Database.Name |
          %{$_.TotalItemSize.value.ToMb()} |
            Measure-Object -Average            

        New-Object PSObject -Property @{
            Server = $Database.Server.Name
            DatabaseName = $Database.Name
            LastFullBackup = $Database.LastFullBackup
            MailboxCount = $MBCount
            "DatabaseSize (GB)" = $DBSize.ToGB()
            "AverageMailboxSize (MB)" = $MBAvg.Average
            "WhiteSpace (MB)" = $Database.AvailableNewMailboxSpace.ToMb()
        }
    }
}
0
 
LVL 17

Accepted Solution

by:
Gaurav Singh earned 167 total points
Comment Utility
0
 

Author Closing Comment

by:DEFclub
Comment Utility
thxs
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Utilizing an array to gracefully append to a list of EmailAddresses
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
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…

772 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