Mailbox count and edb File Size

Script found on the internet

Mailbox Per Server

Get-MailboxDatabase Get-MailboxStatistics Group-Object -property:serverName Sort-Object -property:count Format-Table count, name –AutoSize

Number of Mailboxes

Get-MailboxDatabase Get-MailboxStatistics Group-Object

Mailbox count for each Database

Get-MailboxDatabase Get-MailboxStatistics Group-Object -property:database Sort-Object -property:count Format-Table count, name –AutoSize

EDB File Size

$exchangeservers = Get-ExchangeServer where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
foreach ($server in $exchangeservers)
{
$db = Get-MailboxDatabase -server $server
foreach ($objItem in $db)
{
$edbfilepath = $objItem.edbfilepath
$path = "`\`\" + $server + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$" + $objItem.EdbFilePath.PathName.Remove(0,2)
$dbsize = Get-ChildItem $path
$ReturnedObj = New-Object PSObject
$ReturnedObj Add-Member NoteProperty -Name "Server\StorageGroup\Database" -Value $objItem.Identity
$ReturnedObj Add-Member NoteProperty -Name "Size (MB)" -Value ("{0:n2}" -f ($dbsize.Length/1024KB))
Write-Output $ReturnedObj
}
}