Powershell gets Exchange mailbox user quota
Customer scenario: mailbox quotas have been configured separately for many users. If you want to replan, you now need to lead to the implementation of the actual capacity list of all users: code directly.
# load Exchange command
Add-PSSnapin Microsoft.ex*
# main command
[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,ProhibitSendQuota,DBName
$Temp.Name = $Mail.Name
$Temp.ProhibitSendQuota = $MailQuota
$Temp.DBName = $DBName
# $Temp
$output + = $Temp
}
}
$output | Export-Csv MailQuota.csv-NoTypeInformation-Encoding UTF8
Output result:
In contrast to expectations:
Conclusion: if the user is configured with unlimited capacity, it can not be obtained normally (in the actual customer environment, only the chairman has unlimited configuration, manual correction, in line with customer needs), welcome to help solve this bug
Update: the customer raised several questions: 1. As a result, I can't see which users have manually configured 2. I don't know how much users use or how much space they use. The last login time is required. I have a lot of Mail Server, what if I only want to get one? 5. I opened this script on disk C, but the actual location of the script is on disk D. what if the output file is output to disk C? Need to output to the directory where the script is located
For the above, the script is optimized:
Go directly to the script first.
Param ($Server)
$outfile = $(Split-Path-Parent $MyInvocation.MyCommand.Definition) + "\" + (Get-Date-UFormat "% Y-%m-%d_%H-%M-%S") + ".csv"
Write-Host $outfile
[array] $output = "" | Select Name,DBName,UserQuota,DBQuota,ProhibitSendQuota,TotalItemSize,Use,LastLogonTime
# Select Name,DBName,UserQuota,DBQuota,ProhibitSendQuota,TotalItemSize,Use
Add-PSSnapin Microsoft.ex
If ($Server) {
$DBs = Get-MailboxDatabase-Server $Server | Select Name,ProhibitSendQuota
} else {
$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-ResultSize unlimited | Select SamaccountName,ProhibitSendQuota
Foreach ($Mail in $Mails) {
If ($Mail.ProhibitSendQuota-eq "Unlimited") {
[string] $MailQuota = $DBQuota
}
Else {
[string] $MailQuota = $Mail.ProhibitSendQuota
}
$TotalItemSize = Get-MailboxStatistics-Identity $Mail.SamaccountName | select TotalItemSize,LastLogonTime
$TempA = $Mail.ProhibitSendQuota
$Temp = "" | Select Name,DBName,UserQuota,DBQuota,ProhibitSendQuota,TotalItemSize,Use,LastLogonTime
$Temp.Name = $Mail.SamaccountName
$Temp.DBName = $DBName
If ($TempA-eq "Unlimited") {
$Temp.UserQuota = $TempA
} else {
# $Temp.UserQuota = $TempA.replace ("", "). Split (" (") [0]
$Temp.UserQuota = $($TempA-replace ""). Split ("(") [0]
}
$Temp.DBquota = $($DBQuota-replace ""). Split ("(") [0]
$Temp.ProhibitSendQuota = $($MailQuota-replace ""). Split ("(") [0]
$Temp.TotalItemSize = $($TotalItemSize.TotalItemSize-replace ""). Split ("(") [0]
$Temp.Use = ('{0:n2}'- f $($Temp.TotalItemSize / $Temp.ProhibitSendQuota 100)) +'%'
$Temp.LastLogonTime = $TotalItemSize.LastLogonTime
# $Temp
$output + = $Temp
}
}
# $output [1..$ output.count]
$output [1. $output.count] | Export-Csv $outfile-NoTypeInformation-Encoding UTF8-Force
Output result
Script scanning mode
a. If you execute directly, you get all users.
B.\ xxx.ps1-Server XX gets the DB on the specified Server
Welcome to add
