Investigating RecipientEmailAddress in Microsoft Defender XDR.
The phishing email looked convincing.
Multiple users reported receiving it.
Agent Foskett needed to identify every mailbox that received the message.
The answer was hidden inside RecipientEmailAddress.
In Microsoft Defender XDR, RecipientEmailAddress helps defenders investigate message delivery, phishing campaign reach, targeted users and email distribution activity.
Lesson overview
Learn how to investigate RecipientEmailAddress in EmailEvents and map suspicious messages to affected mailboxes, users, departments and campaign scope.
Why RecipientEmailAddress matters
The fields used in this lesson
Step 1 — Review RecipientEmailAddress activity
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
EmailEvents
| where Timestamp > ago(30d)
| where isnotempty(RecipientEmailAddress)
| project Timestamp,
RecipientEmailAddress,
SenderFromAddress,
SenderFromDomain,
Subject
| order by Timestamp desc
Step 2 — Count messages by recipient
- 1
- 2
- 3
- 4
- 5
- 6
- 7
EmailEvents | where Timestamp > ago(30d) | where isnotempty(RecipientEmailAddress) | summarize MessageCount = count() by RecipientEmailAddress | order by MessageCount desc
Step 3 — Find recipients of suspicious messages
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
EmailEvents
| where Timestamp > ago(30d)
| where isnotempty(RecipientEmailAddress)
| where isnotempty(ThreatTypes)
| project Timestamp,
RecipientEmailAddress,
SenderFromAddress,
Subject,
ThreatTypes,
DeliveryAction
| order by Timestamp desc
Step 4 — Find all recipients from a suspicious sender
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
EmailEvents
| where Timestamp > ago(30d)
| where SenderFromAddress == "sender@domain.com"
| project Timestamp,
RecipientEmailAddress,
Subject,
DeliveryAction,
ThreatTypes
| order by Timestamp desc
Step 5 — Measure campaign reach by subject
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
EmailEvents
| where Timestamp > ago(30d)
| summarize RecipientCount = dcount(RecipientEmailAddress),
MessageCount = count()
by Subject,
SenderFromAddress
| order by RecipientCount desc
Step 6 — Compare recipients with delivery outcomes
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
EmailEvents
| where Timestamp > ago(30d)
| where isnotempty(RecipientEmailAddress)
| summarize MessageCount = count()
by RecipientEmailAddress,
DeliveryAction,
DeliveryLocation
| order by MessageCount desc
How to read the results
Common investigation uses
Common mistakes
What you learned
Related Agent Foskett Academy lessons
Coming next
Final thought
Investigating RecipientEmailAddress in Microsoft Defender XDR
Agent Foskett Academy Lesson 67 teaches defenders how to investigate RecipientEmailAddress during Microsoft Defender XDR email investigations.
Learn RecipientEmailAddress investigation in Defender XDR
This lesson explains how RecipientEmailAddress, SenderFromAddress, Subject, DeliveryAction, DeliveryLocation and ThreatTypes help defenders identify affected mailboxes, scope phishing campaigns and investigate email distribution activity.
