Get Exchange MailboxDB utilisation

Get Exchange MailboxDB utilisation

Again, a simple script to get information from your current Exchange Environment regarding the utilisation of your MailboxDBs

[cc lang=”powershell”]

##############################################################################
#
# Powershell script to to get Exchange mailbox utilization
# Will list the amount of Mailboxes within each DB.
# Will also show DB space and White space within that DB.
#
# Niall
#
##############################################################################

$ScriptPath = Split-Path $MyInvocation.InvocationName
$date = Get-Date -Format dd-MM-yy
Get-Mailbox | Group-Object -Property:Database | Select-Object Name,Count | ft -auto >> $scriptPath\Get-ExchangeMailDBUsage-results-$date.txt
Get-MailboxDatabase -Status | sort name | select name,@{Name=’DB Size (Mb)’;Expression={$_.DatabaseSize.ToGb()}},@{Name=’Available New Mbx Space Gb)’;Expression={$_.AvailableNewMailboxSpace.ToGb()}} >> $scriptPath\Get-ExchangeMailDBUsage-results-$date.txt

[/cc]

This will give you an output something like this:

[cc]

Name                                                               DB Size (Gb)             Available New Mbx Space Gb)
—-¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† ————¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† —————————
ArbitrationMBDB                                                               0                                       0
DB01                                                                         27                                       1
DB02                                                                         30                                       0
DB03                                                                         26                                       0
DB04                                                                         29                                       1
DB05                                                                         29                                       2
DB06                                                                         27                                       0
DB07                                                                         32                                       0
DB08                                                                         29                                       0
PublicFolderDB1                                                               0                                       0

[/cc]

 

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *