Quick Tip (Revisited) – How to get the physical sizes of Exchange Databases (in different versions of Exchange from a single script)

A couple of weeks back I published a very simple script which I had been using on a few versions of Exchange to determine the physical sizes of each of the EDB files. A reader commented that in Exchange 2010 – such an elaborate script was not needed as the Get-MailboxDatabase cmdlet contains a “DatabaseSize” property which is populated from the Information Store on each mailbox server when the “–Size” parameter is used.

Bjarni Kristjansson

Or this one liner… Get-MailboxDatabase –server <ServerName> -status | select ServerName,Name,DatabaseSize
Rgds. BK

Of course Bjarni was correct – but his comment led me to consider how I had been using my original script. As I was familiar with the code and the environments that I was executing it within – I would modify it to essentially “work” when it stopped doing so – however, when I published a version of the the code on telnetport25.com – I discovered that what I produced was not all encompassing (or generic enough). Therefore;

Execution against Clustered 2007 Instances would not return any data
The script did not account for different versions of Exchange, and therefore did not use the most optimal command line syntax between 2007 and 2010

Given the above I have re-written the original script (and replaced the download with the new script) so that it will now:

Recognise the different syntax between the cmdlets required by Exchange 2010 and Exchange 2007
If the host environment is Exchange 2007, determine if the mailbox is hosted on a cluster or a basic Exchange instance and report on the physical database sizes

In order to work correctly in an Exchange 2007 environment the account in which the context of the script is run needs to have access to the hidden share at the root of each Exchange server (c$ for example).

Aside from the mail purpose of the script, there are some other learning points contained within its syntax – for example;

Exchange 2007 / 2010 – How to simply detect the major version of the Exchanger on a given server
Exchange 2007 CCR – How to determine the Active CCR node

The output of this script looks like the following depending on the version of Exchange that it executes against:

Exchange 2010

28-10-201213-11-07

Exchange 2007

28-10-201214-15-12

The (revised) Script

You can review the script below, or you can click on the download link provided in the Download section.

<#
.DESCRIPTION
   Sample Script to demonstrate how you can get the physical Database Size for both Exchange 2007 and 2010
.CREDITS & COPYRIGHT
    2012 (c) Telnetport25.com - Released under the GNU version 3.0
    Author: Andy Grogan
.VERSION
    2.0 - Revised Version
#>

function GetExchangeMajorVersion{
    param(

        $ExchangeServer

    )
    $SVR = Get-ExchangeServer $ExchangeServer

    # Build a simple differentiation between Exchange 2007 and 2010

    if($SVR.AdminDisplayVersion.Major -eq 8){
        return "2007"

    }elseif($SVR.AdminDisplayVersion.Major -eq 14){
        return "2010"
    }else{
        Write-Host "This script is not supported on versions of Exchange prior to 2007" -ForegroundColor Red
    }

}

function get_isACluster{
    param ($Server)

    $isCluster = Get-MailboxServer -Identity $Server | Select Name,ClusteredStorageType
    if($isCluster.ClusteredStorageType -ne 'Disabled'){
            return "Clustered"
        }else{
            return "notClustered"
        }
}

function get_ActiveNode{
    param(

        $Server

    )
    $2007Cluster = Get-MailboxServer $Server
    if($2007Cluster.ClusteredStorageType -ne "Disabled"){
           $Stat = Get-ClusteredMailboxServerStatus $2007Cluster.Name | Select -Expand OperationalMachines | foreach {if($_ -like "*Active*") {$_}}
           $AN = $Stat.Split(" ")[0]
           return $AN
    }
}

function get_DBSize2007Cluster{
    param(
        $Server, $DatabaseName
    )
        Write-Host "Working on Mailbox Database Server: " $Server -ForegroundColor "White"
        $aNode = get_ActiveNode $Server
        $thisDB = Get-MailboxDatabase -Identity $DatabaseName
        Write-Host "Working against database: " $thisDB -ForegroundColor Green
        Write-Host "Operational Cluster Node: " $aNode -ForegroundColor Yellow

        $Path = "`\`\" + $aNode + "`\" + $thisDB.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $thisDB.EdbFilePath.PathName.Remove(0,2)
        Write-Host $Path
        $EdbFile = Get-ChildItem $Path
        $DBSize = $EdbFile.length / 1GB
        $Result = [Math]::Round($DBSize,2)
        return $Result

}

function get_DBSize2007NONCluster{
    param(
        $Server
    )
        Write-Host "Working on Mailbox Database Server: " $Server -ForegroundColor "White"

        $DBS = Get-MailboxDatabase -Server $Server

        foreach($DB in $DBS){
            Write-Host "Working against database: " $DB.Name -ForegroundColor "Green"
            $Path = "`\`\" + $Server + "`\" + $DB.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $DB.EdbFilePath.PathName.Remove(0,2)
            $EdbFile = Get-ChildItem $Path
            $DBSize = $EdbFile.length / 1GB
            $Result = [Math]::Round($DBSize,2)
            return $Result
        }

}

$Servers = Get-MailboxServer | Select -ExpandProperty Name

foreach($Server in $Servers){
     $result = GetExchangeMajorVersion $Server
    if($result -eq "2007"){
        $is2007Clustered = get_isACluster $Server
        if($is2007Clustered -eq "Clustered"){
            # Get databases paths of the databases on the cluster
            $DatabasesONCluster = Get-MailboxDatabase -Server $Server | Select -expandProperty Identity
            foreach($entry in $DatabasesONCluster){
                get_DBSize2007Cluster $Server "$entry"
            }

        }elseif($is2007Clustered -eq "notClustered"){
            get_DBSize2007NONCluster $Server
        }
    }elseif($Result -eq "2010"){
        Get-MailboxDatabase -server $Server -status | select ServerName,Name,DatabaseSize
    }
}