Query Details
# Sentinel - Email sending limit exceeded ## Query Information ### Description Use the below query to review 'Email sending limit exceeded' incidents. #### References ### Microsoft Sentinel ```kql let lookBack = 7d; let IncTitle = "Email sending limit exceeded"; SecurityIncident | where TimeGenerated > ago(lookBack) | where Title == IncTitle | summarize arg_max(TimeGenerated,*) by IncidentNumber | mv-expand AlertIds | extend AlertId = tostring(AlertIds) | join (SecurityAlert) on $left. AlertId == $right. SystemAlertId | mv-expand parse_json(Entities) | extend EType = tostring((Entities.Type)) | where EType == "mailbox" | extend MailboxPrimaryAddress = tostring(Entities.MailboxPrimaryAddress) | extend DisplayName = tostring(Entities.DisplayName) ```
This query is used to review incidents where the email sending limit has been exceeded. It looks back at incidents that occurred within the last 7 days and filters for incidents with the title "Email sending limit exceeded". It then retrieves the latest incident information for each incident number and expands the alert IDs. It joins the alert IDs with the security alerts and expands the JSON entities. It filters for entities of type "mailbox" and retrieves the mailbox primary address and display name.

Alex Verboon
Released: November 3, 2023
Tables
Keywords
Operators