Count Exchange mailbox by day

Dear DIMITRI,

Thank you very much for your KB-post.

My colleague Dieter wrote a script which should help you with your request. Using this script you can use PRTG´s native EXE/Script Advanced Sensor.

• Please save this script as Get-MailcountReceivedYesterdayTodayForUser.ps1 under C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXE
• Deploy a EXE/Script Advanced Sensor to your Exchange device
• Please use the following syntax for the parameter-setting within PRTG:
  • -server <fqdn of the server> -user <loginname> -pass <password> -recipient <smtp-address to check for mails>
• Save the settings.
  Please let us know if this works fine for you.

Kind regards,
Sven

Param(
    $server,
    $user, 
    $pass,
    $recipient
)

<# use the following syntax for the parameter-setting within PRTG:
    -server <fqdn of the server> -user <loginname> -pass <password> -recipient <smtp-address to check for mails>
or simple to use presets within the device:
    -server %host -user %windowsdomain\%windowsuser -pass %windowspassword -recipient <smtp-address to check for mails>
#>

$prtg = ‘<?xml version="1.0" encoding="utf-8" ?> 
<prtg> 
‘ 

try {
    $secPw = ConvertTo-SecureString $pass -AsPlainText -Force
    $credential = New-Object System.Management.Automation.PSCredential ($user, $secPw)

    $Session = New-PSSession -ConfigurationName Microsoft.Exchange `
        -ConnectionUri http://$server/PowerShell/ `
        -credential $credential 
    Import-PSSession $session -AllowClobber

    $msgsSinceYesterday = Get-MessageTrackingLog -ResultSize Unlimited -Start (get-date (get-date).AddDays(-1) -f ((New-Object System.Globalization.CultureInfo(“en-US”)).DateTimeFormat.ShortDatePattern)) -Recipients $recipient -EventId Receive

    $msgsSinceYesterdayGrouped = $msgsSinceYesterday | select timestamp | Group-Object {$_.timestamp.date}

    if ($msgsSinceYesterdayGrouped.count -eq 2) { 
        $mailsYesterday = $msgsSinceYesterdayGrouped[0].count
        $mailsToday = $msgsSinceYesterdayGrouped[1].count
    } elseif ($msgsSinceYesterdayGrouped.count -eq 1) { # this may happen if there is NO mail within one day for example during night or at the weekend
        if ((get-date($msgsSinceYesterday[0].name)).Date -lt (get-date).Date) {
            $mailsYesterday = $msgsSinceYesterdayGrouped[0].count
            $mailsToday = 0
        } else {
            $mailsYesterday = 0
            $mailsToday = $msgsSinceYesterdayGrouped[0].count
        }
    } else {
            $mailsYesterday = 0
            $mailsToday = 0
    }

    $prtg +="  <result> 
        <channel>Mails Today</channel> 
        <value>$mailstoday</value> 
        <unit>custom</unit>
        <customunit>emails</customunit>
        <showChart>1</showChart> 
        <showTable>1</showTable> 
    </result> 
    <result> 
        <channel>Mails Yesterday</channel> 
        <value>$mailsyesterday</value> 
        <unit>custom</unit>
        <customunit>emails</customunit>
        <showChart>1</showChart> 
        <showTable>1</showTable> 
    </result>
" 

    $prtg +="    <text>OK</text> 
</prtg>" 
    

} catch {
    $errormessage = $_.Exception.Message
    $prtg +="  <error>1</error>" 
    $prtg +="  <text>$errormessage</text> 
    </prtg>" 
    
} finally {
    if ($Session -ne $null) { Remove-PSSession $Session; }
}
$prtg