Solved

managing exch 2010 bd sizes

Posted on 2012-03-15
4
358 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
ID: 37725406
0
 
LVL 7

Assisted Solution

by:ingetic
ingetic earned 166 total points
ID: 37725427
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
ID: 37725655
0
 

Author Closing Comment

by:DEFclub
ID: 37726355
thxs
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
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 an Address List 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 Organization >> Ad…
In this video we show how to create an Accepted Domain 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 >> Ac…

910 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

24 Experts available now in Live!

Get 1:1 Help Now