$userlist = @();
#create the mail message
$mail = New-Object System.Net.Mail.MailMessage
$mail.From = New-Object System.Net.Mail.MailAddress($MailAddress)
$mail.To.Add($MailtoAddress)
#set the content
$mail.Subject = “Q郵箱空間使用情況統計”;
foreach($db in $dblist){
$dbName = $db.Name;
$dbInfo = Get-MailboxDatabase $dbName | select IssueWarningQuota;
$dbWQ = $dbInfo.IssueWarningQuota.Value.ToMB();
$uper= $dbWQ * 0.8;
$object_part = $dbWQ * 0.2;
$alluser=Get-MailboxStatistics -database $dbName |Where-Object {$_.TotalItemSize.Value.ToMB() -ge $uper} | Sort-Object TotalItemSize -Descending | select-object displayname,totalitemsize
$Mailbox = Get-Mailbox -Database $dbName| select-object DisplayName,primarysmtpaddress;
foreach($user in $alluser){
$displayname = $user.DisplayName;
$totalitemsize = $user.TotalItemSize.Value;
$mypriadd= $Mailbox | where-object {$_.DisplayName -eq $displayname;} | select-object primarysmtpaddress;
$mylocal = $mypriadd.PrimarySmtpAddress.Local;
$myadd = $mylocal “@contoso.com”;
$userobject=New-object psobject;
$userobject | Add-Member -membertype noteproperty -Name 用戶名 -value $displayname;
$userobject | Add-Member -membertype noteproperty -Name 郵箱已用空間 -Value $totalitemsize;
$userobject | Add-Member -membertype noteproperty -Name 郵件地址 -Value $myadd;
$userlist =$userobject;
if($mylocal -ne $null){
$mail_user = New-Object System.Net.Mail.MailMessage
$mail_user.From = New-Object System.Net.Mail.MailAddress($MailAddress)
#set the content
$mail_user.Subject = “郵箱空間已不足20%”;
#$MailtoAddress_user=$MailtoAddress; #$myadd;
$mail_user.To.Add($myadd)
$EmailbodyHTML_user= “您的郵箱空間不足20%,%u8BF7及時歸檔郵件或者聯系IT支持幫助處理。<br/> 聯系方式：Administrator@contoso.com”; #| Out-String # ConvertTo-Html |
$mail_user.Body = $EmailbodyHTML_user;
$mail_user.IsBodyHtml = $true;
#send the message
$smtp_user= New-Object System.Net.Mail.SmtpClient -argumentList $smtpServer;
$smtp_user.Credentials = New-Object System.Net.NetworkCredential -argumentList $smtpUser,$smtpPassword;
$smtp_user.Send($mail_user);
}
}
}
$EmailbodyHTML=$userlist| ConvertTo-Html | Out-String
$mail.Body = $EmailbodyHTML
$mail.IsBodyHtml = $true
#send the message
$smtp = New-Object System.Net.Mail.SmtpClient -argumentList $smtpServer
$smtp.Credentials = New-Object System.Net.NetworkCredential -argumentList $smtpUser,$smtpPassword
$smtp.Send($mail)
以上實現了，領導的要求，可以根據自己的實際情況調整相關代碼，第一次上傳文章，分享知識心得！
如果，你對上面的內容還有疑問，推薦選擇三五互聯企業云郵箱！有專人協助您解答郵箱疑問。
三五互聯優質企業郵箱服務商，提供安全穩定，簡單易用，高性價比的企業郵箱。按需自由定制，不限空間，極速收發，能夠滿足用戶對企業郵箱的不同需求。多種反垃圾郵件算法，99.9%精準度，智能過濾，減少垃圾郵件干擾。支持小程序收發郵件，隨時隨地移動辦公。而且價格實惠，還可以免費試用，7×24小時專業團隊服務支持！
高性價比企業郵箱開通鏈接：http://www.shinetop.cn/services/mail/