table

EmailEvents

EmailEvents contains Microsoft 365 email delivery and blocking events processed by Microsoft Defender for Office 365.

tablesCurrent

Relationships

Schema

FieldTypeDescriptionCopy
TimestampdatetimeDate and time when the event was recorded.
NetworkMessageIdstringUnique identifier for the email, generated by Microsoft 365.
InternetMessageIdstringPublic-facing identifier set by the sending email system.
SenderMailFromAddressstringSender address from the MAIL FROM header, also known as the envelope sender.
SenderFromAddressstringSender email address in the visible From header.
SenderDisplayNamestringDisplay name shown for the sender.
SenderObjectIdstringMicrosoft Entra ID object ID for the sender account.
SenderMailFromDomainstringSender domain from the MAIL FROM header.
SenderFromDomainstringSender domain from the visible From header.
SenderIPv4stringIPv4 address of the last detected mail server that relayed the message.
SenderIPv6stringIPv6 address of the last detected mail server that relayed the message.
RecipientEmailAddressstringEmail address of the recipient.
RecipientObjectIdstringMicrosoft Entra ID object ID for the recipient account.
SubjectstringSubject of the email.
EmailClusterIdlongIdentifier for a group of similar emails clustered through content analysis.
EmailDirectionstringDirection of the message relative to the organization, such as inbound, outbound, or intra-org.
DeliveryActionstringDelivery action of the email, such as Delivered, Junked, Blocked, or Replaced.
DeliveryLocationstringLocation where the email was delivered.
ThreatTypesstringVerdict from the email filtering stack on whether the email contains malware, phishing, or other threats.
ThreatNamesstringDetection name for malware or other threats found.
DetectionMethodsstringMethods used to detect malware, phishing, or other threats.
ConfidenceLevelstringSpam or phishing confidence level assigned by filtering.
BulkComplaintLevelintBulk complaint level assigned to email from bulk senders.
EmailActionstringFinal action applied to the message based on verdicts, policies, and user actions.
EmailActionPolicystringPolicy category that determined the final email action.
EmailActionPolicyGuidstringUnique identifier for the policy that determined the final action.
AuthenticationDetailsstringAuthentication verdicts such as DMARC, DKIM, SPF, or composite authentication.
AttachmentCountintNumber of attachments in the email.
UrlCountintNumber of embedded URLs in the email.
EmailLanguagestringDetected language of the email content.
ConnectorsstringCustom mail flow routing instructions or connectors that affected the message.
OrgLevelActionstringAction taken because of an organization-level policy match.
OrgLevelPolicystringOrganization-level policy that triggered the action.
UserLevelActionstringAction taken because of a user mailbox policy match.
UserLevelPolicystringUser mailbox policy that triggered the action.
ReportIdstringEvent identifier based on a repeating counter.
AdditionalFieldsstringAdditional event or entity details.
LatestDeliveryLocationstringLast known location of the email; not available in the Streaming API.
LatestDeliveryActionstringLast known delivery action attempted by the service or by admin remediation; not available in the Streaming API.
DistributionListstringTop-level distribution list to which the email was sent, when applicable.
ExchangeTransportRulestringMail flow rule that acted on the message while it was in transit.
ForwardingInformationstringJSON-formatted forwarding details, including forwarding user and forwarding type.
ContextstringProtection context in which the detection ran.
TostringAddresses listed in the To header.
CcstringAddresses listed in the Cc header.
ThreatClassificationstringThreat classification assigned to the email.
RecipientDomainstringDomain portion of the recipient address.
EmailSizelongSize of the email message in bytes.
IsFirstContactintIndicates whether this was the first contact between the sender and recipient.

Sample KQL

Inbound phishing delivery by sender domain

Summarize inbound messages with phishing verdicts and where they landed.

kql
EmailEvents
| where Timestamp > ago(7d)
| where EmailDirection == "Inbound"
| where ThreatTypes has "Phish" or ThreatClassification has "Phish"
| summarize Messages=count(), Recipients=dcount(RecipientEmailAddress) by SenderFromDomain, DeliveryAction, DeliveryLocation
| order by Messages desc

Messages with URL and attachment exposure

Identify messages that combine embedded links and attachments for follow-up joins with UrlClickEvents and EmailAttachmentInfo.

kql
EmailEvents
| where Timestamp > ago(3d)
| where UrlCount > 0 and AttachmentCount > 0
| project Timestamp, NetworkMessageId, SenderFromAddress, RecipientEmailAddress, Subject, ThreatTypes, UrlCount, AttachmentCount
| order by Timestamp desc