Query Details
**Detecting domains where their emails will be routed to Junk folders due to new Outlook requirement** Microsoft has reported that After May 5th, 2025, Outlook will begin routing messages from high volume nonโcompliant domains to the Junk folder, giving senders an opportunity to address any outstanding issues. ๐๐๐๐: ๐ญ๐ก๐๐ญ ๐ข๐ง ๐ญ๐ก๐ ๐๐ฎ๐ญ๐ฎ๐ซ๐ (๐๐๐ญ๐ ๐ญ๐จ ๐๐ ๐๐ง๐ง๐จ๐ฎ๐ง๐๐๐), ๐ง๐จ๐ง-๐๐จ๐ฆ๐ฉ๐ฅ๐ข๐๐ง๐ญ ๐ฆ๐๐ฌ๐ฌ๐๐ ๐๐ฌ ๐ฐ๐ข๐ฅ๐ฅ ๐๐ ๐ซ๐๐ฃ๐๐๐ญ๐๐ ๐ญ๐จ ๐๐ฎ๐ซ๐ญ๐ก๐๐ซ ๐ฉ๐ซ๐จ๐ญ๐๐๐ญ ๐ฎ๐ฌ๐๐ซ๐ฌ. For domains sending over 5,000 emails per day, Outlook will soon require compliance with SPF, DKIM, DMARC. Nonโcompliant messages will first be routed to Junk. If issues remain unresolved, they may eventually be rejected. Senders will soon start requiring compliance with the following requirements: - SPF (Sender Policy Framework) Must Pass for the sending domain. Your domain's DNS record should accurately list authorized IP addresses/hosts. - DKIM (DomainKeys Identified Mail) Must Pass to validate email integrity and authenticity. - DMARC (Domain-based Message Authentication, Reporting, and Conformance) At least p=none and align with either SPF or DKIM (preferably both). ``` EmailEvents | where Timestamp > ago(1d) | extend SPF = tostring(parse_json(AuthenticationDetails).SPF) | extend DMARC = tostring(parse_json(AuthenticationDetails).DMARC) | extend DKIM = tostring(parse_json(AuthenticationDetails).DKIM) | where SPF !has "pass" or DMARC !has "pass" or DKIM !has "pass" | summarize Total_Emails=count() by InternetMessageId, SenderFromDomain, SPF, DMARC, DKIM | where Total_Emails > 4000 | order by Total_Emails ```
This query is designed to identify email domains that are at risk of having their emails sent to the Junk folder in Outlook due to non-compliance with certain email authentication standards. Here's a simplified breakdown of what the query does:
Data Source: It looks at email events from the past day.
Extract Authentication Details: It extracts the results of three email authentication checks: SPF, DKIM, and DMARC, from the email's authentication details.
Filter Non-Compliant Emails: It filters out emails that did not pass any of these checks (SPF, DKIM, or DMARC).
Count Emails by Domain: It counts the total number of non-compliant emails for each domain.
Identify High-Volume Senders: It focuses on domains that have sent more than 4,000 non-compliant emails in the past day.
Sort Results: Finally, it sorts these domains by the total number of non-compliant emails sent.
The purpose of this query is to help identify domains that need to improve their email authentication practices to avoid having their emails marked as junk or eventually rejected by Outlook.

Sergio Albea
Released: April 4, 2025
Tables
Keywords
Operators