My-Technet

A storage status of “NoChecking” means they do not have a mailbox limit.

To schedule the script. Through Windows Scheduler “PowerShell.exe -PSConsoleFile "C:\Program Files\Microsoft\Exchange Server\Bin\ExShell.psc1" -Command “C:\Script.ps1"

Save as a .ps1 file

________________________________________________

$FromAddress=MailboxReport@domain.com

$ToAddress=ExampleUser@domain.com

$MessageSubject="Mailbox Report"

$MessageBody="User Mailbox Storage Limit Status"

$SendingServer="emailserver.domain.com"

$file="C:\Mailboxes.txt"

Get-MailboxStatistics | Sort-Object StorageLimitStatus | ft DisplayName, StorageLimitStatus, ItemCount > $file

$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress, $MessageSubject, $MessageBody

$Attachment = new-object System.Net.Mail.Attachment $file

$SMTPMessage.Attachments.Add($Attachment)

$SMTPClient=New-Object System.Net.Mail.SMTPClient $SendingServer

$SMTPClient.Send($SMTPMessage)