Powershell获取Exchange 邮箱用户配额

客户场景：为很多用户单独配置过邮箱配额，想重新规划，现需要导致所有用户实际容量清单 实现方式：直接上代码

#加载Exchange命令
Add-PSSnapin Microsoft.ex*
#主命令
[array]$output = "" | SELEct Name,ProhibitSendQuota,DBName
$DBs = Get-MailBoxDatabase | SELEct Name,ProhibitSendQuota
foreach ($DB in $DBs) {
[String]$DBQuota = $DB.ProhibitSendQuota
[String]$dbname = $DB.Name
Write-Host "Database $DBName‘s quota is $DBQuota"
$Mails = Get-MailBox -Database $DBName | SELEct Name,ProhibitSendQuota
foreach ($Mail in $Mails) {
if ($Mail.ProhibitSendQuota -eq "Unlimited") {
[String]$MailQuota = $DBQuota
}
else {
[String]$MailQuota = $Mail.ProhibitSendQuota
}

$Temp = "" | SELEct Name,DBName
$Temp.Name = $Mail.Name
$Temp.prohibitSendQuota = $MailQuota
$Temp.dbname = $DBName
#$Temp

$output += $Temp

}
}
$output | Export-Csv MailQuota.csv -NoTypeInformation -Encoding UTF8
输出结果：

与预期对比：

结论：如果为用户配置了不限制容量，则不能正常获取（客户实际环境中仅为董事长有配置无限制，手动修正，符合客户需求），欢迎帮解决此bug