[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

managing exch 2010 bd sizes

How can I report on the size of ex2010 DBs, how many users are in each DB, size of their mailboxes etc?
0
DEFclub
Asked:
DEFclub
3 Solutions
 
R--RCommented:
0
 
ingeticCommented:
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
 
Gaurav SinghSolution ArchitectCommented:
0
 
DEFclubAuthor Commented:
thxs
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now