Query Details
let TempEmailAddresses = externaldata (mail: string) [@'https://raw.githubusercontent.com/jkerai1/TLD-TABL-Block/refs/heads/main/tempmail-abused%20emaildomains.txt'] with (format=csv, ignoreFirstRecord=False); EmailEvents | where TimeGenerated > ago(90d) | where SenderFromDomain has_any (TempEmailAddresses) or RecipientEmailAddress has_any(TempEmailAddresses) // Visit https://github.com/jkerai1/TLD-TABL-Block for Block Script
This KQL (Kusto Query Language) query is designed to identify email events involving temporary or potentially abused email domains. Here's a simple breakdown of what the query does:
Load Temporary Email Domains: It first loads a list of temporary or abused email domains from an external CSV file hosted on GitHub. This list is stored in a variable called TempEmailAddresses.
Filter Email Events: The query then looks at email events from the EmailEvents table that have occurred in the last 90 days.
Check for Matches: It filters these email events to find any where the sender's domain or the recipient's email address matches any of the domains in the TempEmailAddresses list.
In essence, the query is used to detect email communications that involve potentially suspicious or temporary email domains within the last 90 days.

Jay Kerai
Released: November 11, 2024
Tables
Keywords
Operators