Get-MailboxStatistics -Database 'Mailbox Database 123' |
Where-Object {$_.TotalItemSize.Value.ToMB() -le 5} | 
Sort-Object TotalItemSize -Descending | 
Select-Object DisplayName,TotalItemSize

问题是，Get-MailboxStatistics输出只是一个显示名称-不是唯一的，不能真正这样使用。另一半的信息，你需要的是在Get-Mailbox：-在下面的链接找到答案。一旦你有了所有邮箱的数据，输出可以导入到Excel中，你可以做你所有的排序等，并删除任何你不想要的
如果这是你要找的，请点击这个链接，给予那个家伙一些信任。。我没有想出这个，我只是找到了它

#REM http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/Q_27828458.html

$Mailboxes = Get-Mailbox -ResultSize Unlimited
foreach ($Mailbox in $Mailboxes)
{
 $Mailbox | Add-Member -MemberType "NoteProperty" -Name "MailboxSizeMB" -Value ((Get-MailboxStatistics $Mailbox).TotalItemSize.Value.ToMb())
}
$Mailboxes | Sort-Object MailboxSizeMB -Desc | Select PrimarySMTPAddress, MailboxSizeMB

#REM - to export this out -- do the following ;) enjoy (see the part where it says "Select" you can add additional fields like ALIAS etc to this)

$Mailboxes = Get-Mailbox -ResultSize Unlimited
foreach ($Mailbox in $Mailboxes)
{
 $Mailbox | Add-Member -MemberType "NoteProperty" -Name "MailboxSizeMB" -Value ((Get-MailboxStatistics $Mailbox).TotalItemSize.Value.ToMb())
}
$Mailboxes | Sort-Object MailboxSizeMB -Desc | Select PrimarySMTPAddress, MailboxSizeMB | Export-Csv -NoType "C:\temp\Mailboxessize.csv"

转到AD并提取所有用户 * 查看高级功能|添加列Exchange邮箱存储，电子邮件地址在Excel中合并这两个列表，享受微笑和可乐...你刚刚完成了1周的工作在20分钟内