获取exchange数据库实际大小

在做Exchange2013运维时经常需要查看每个数据库对应邮箱数量和该数据库实际大小。

以下脚本可以解决此问题。

$MailboxList = @();
$DBList = @();
Get-MailboxDatabase | Get-MailboxStatistics | 
foreach {
$Mailbox = New-Object PSObject; 
Add-Member -InputObject $Mailbox -MemberType NoteProperty -Name Size -Value $_.TotalItemSize.psbase.value.ToMB();
Add-Member -InputObject $Mailbox -MemberType NoteProperty -Name DB -Value $_.DatabaseName;
$MailboxList += $Mailbox;
}
$MailboxList |Group-Object -Property DB | foreach{ 
$GroupData = ($_.Group | Measure-Object -Property Size  -Sum);
$DBData = New-Object PSObject; 
Add-Member -InputObject $DBData -MemberType NoteProperty -Name Domain -Value $_.Name; 
Add-Member -InputObject $DBData -MemberType NoteProperty -Name TotalCount -Value $_.Count; 
Add-Member -InputObject $DBData -MemberType NoteProperty -Name PopCount -Value $GroupData.Sum;


$DBList += $DBData;}
$DBList | ft