Find all source-campaign recipients
Finding
Microsoft published the subject NEW PROPOSAL – NDA as a hunting value for the January campaign. The first search uses that source-scoped value to define the recipient population.
Recipients become the bounded starting population; the subject is not treated as a universal AiTM indicator.
View query
Q-01First searchFind all source-campaign recipients
What this checks
Identify every recipient of messages matching Microsoft's January 2026 hunting subject and preserve sender, delivery, and verdict context.
KQL
let lookback = 7d;
EmailEvents
| where Timestamp >= ago(lookback)
| where Subject has "NEW PROPOSAL" and Subject has "NDA"
| summarize
FirstSeen=min(Timestamp),
LastSeen=max(Timestamp),
Messages=count(),
UniqueRecipients=dcount(RecipientEmailAddress),
Recipients=make_set(RecipientEmailAddress, 500),
Senders=make_set(SenderFromAddress, 50),
DeliveryActions=make_set(DeliveryAction, 20),
ThreatVerdicts=make_set(ThreatTypes, 20)
by Subject
| order by LastSeen descSPL
index=<m365_email_index> sourcetype=<email_events_sourcetype>
earliest=-7d
| eval
subject=coalesce(subject, Subject),
sender=lower(coalesce(sender, SenderFromAddress, SenderMailFromAddress)),
recipient=lower(coalesce(recipient, RecipientEmailAddress)),
action=coalesce(action, LatestDeliveryAction, DeliveryAction),
threat_types=coalesce(threat_types, ThreatTypes)
| where like(subject, "%NEW PROPOSAL%") AND like(subject, "%NDA%")
| stats
min(_time) as first_seen
max(_time) as last_seen
count as messages
dc(recipient) as unique_recipients
values(recipient) as recipients
values(sender) as senders
values(action) as delivery_actions
values(threat_types) as threat_verdicts
by subject
| sort - last_seenWhat to look for
A recipient population that can be pivoted into URL-click telemetry.
Technical details
Tested signal
Source-scoped campaign subject across mail telemetry.
Assumptions
- The published subject is used only for the cited January campaign.
- Mail telemetry is retained for the review period.
Data requirements and relevant fields
Mail events with sender, recipient, subject, delivery, and threat context.
TimestampSenderFromAddressSenderMailFromAddressRecipientEmailAddressSubjectDeliveryActionThreatTypes
KQL schema
Uses documented EmailEvents fields and source-scoped subject matching.
SPL schema
Replace index/sourcetype and field aliases with the local message source.
Limitations
- Subject variants can miss related messages.
- Legitimate messages can reuse generic words such as proposal or NDA; the full source context matters.
Both variants scope a source-published hunting value; they do not present the subject as a universal AiTM signature.