Measure-EmailDelayInMTL
Download the latest release: Measure-EmailDelayInMTL.ps1
Generates a report of the maximum message delay for all messages in an Message Tracking Log output.
DESCRIPTION
Gather message tracking log details of all message to / from a given recipient for a given time range. Useful for determining if a "slow" message was a one off or a pattern.
Exchange Online
Recommend using Start-HistoricalSearch in EXO to gather a detailed Message Tracking Log for processing.
Start-HistoricalSearch -ReportTitle "Fabrikam Search" -StartDate 8/10/2024 -EndDate 8/12/2024 -ReportType MessageTraceDetail -SenderAddress michelle@fabrikam.com -NotifyAddress chris@contoso.com
Exchange On Premises
Recommend using Get-MessageTrackingLog in Exchange On Premises for gathering a Message Tracking Log for processing.
Get-TransportService | Get-MessageTrackingLog -Recipients user1@contoso.com -Start 08/10/2024 -End 08/12/2024 | Export-Csv c:\temp\MyMTL.csv
Note: If you provide a raw message tracking log to the script it WILL generate significant errors since many RECEIVE events and DELIVERY events occur on different servers.
PARAMETER
-MTLFile
CSV output of Message Tracking Log to process.
-ReportPath
Folder path for the output file.
Outputs
CSV File
| Header | Description |
|---|---|
| MessageID | ID of the Message |
| TimeSent | First time we see the message in the MTL |
| TimeReceived | Last delivery time in the MTL |
| MessageDelay | How long before the message was delivered |
Note: When loading the CSV in Excel the Message Delay column will need to be formatted as a time span.
Statistical Summary
| Statistic | Description |
|---|---|
| EmailCount | Number of email found in the MTL |
| MaximumDelay | Longest delivery delay found in the MTL |
| MinimumDelay | Shortest delivery delay found in the MTL |
| AverageDelay | Average of all delivery delays across all email in the MTL |
Default Output File:
$PSScriptRoot\MTL_report.csv
EXAMPLE
.\Measure-EmailDelayInMTL -MTLPath C:\temp\MyMtl.csv
.\Measure-EmailDelayInMTL -MTLPath C:\temp\LargeMTL.csv -ReportPath C:\output