Detect threats with Defender XDR
Choosing the right Advanced Hunting table, finding threats with KQL, building hunting queries, threat analytics, hunting graphs with blast radius, and Sentinel graph.
- 22 min
- 6 concepts
- Try it yourself
- 5-question check
Learn
Advanced Hunting lets you query 30 days of raw data from devices, email, identities and cloud apps with KQL. Hunting means looking for attackers that detections haven't caught yet. Try the playground with sample Defender data.
- 1
Identify the appropriate table to use in a KQL query
Device* tables (Defender for Endpoint):
DeviceProcessEvents,DeviceNetworkEvents,DeviceFileEvents,DeviceLogonEvents,DeviceRegistryEvents. Email* (Defender for Office 365):EmailEvents,EmailAttachmentInfo,EmailUrlInfo,UrlClickEvents. Identity* (Defender for Identity and Entra):IdentityLogonEvents,IdentityDirectoryEvents.CloudAppEvents(Defender for Cloud Apps).AlertInfoandAlertEvidencefor alerts.Remember: Process launches: DeviceProcessEvents. Clicks: UrlClickEvents.
- 2
Identify threats by using Kusto Query Language (KQL)
Core operators:
where(filter),project(columns),extend(new columns),summarizewithcount(),dcount(),make_set()(aggregate),join(combine tables, choose the kind),top,sort,ago()for time. String operators:has(whole term, fast),contains(substring, slower),=~(case-insensitive equals),in~.Remember: Prefer has over contains for speed.
- 3
Create Advanced Hunting queries
Start narrow in time, filter early, then shape results. Save queries to shared queries for the team, use query resources and the guided mode for beginners, and turn useful queries into custom detection rules. Results can drive actions: isolate devices, quarantine files, soft-delete email.
Remember: Filter early, by time first.
- 4
Interpret threat analytics in Microsoft Defender XDR
Threat analytics reports from Microsoft researchers cover active threat actors, campaigns, vulnerabilities and techniques. Each report shows an analyst report, related incidents and alerts in your tenant, impacted assets, and exposure and mitigations (unpatched devices, missing settings). Use it to prioritise.
Remember: Are we exposed to this campaign? Threat analytics.
- 5
Create hunting graphs, including blast radius
The hunting graph in Advanced Hunting visualises relationships between users, devices, credentials and resources so you can find privileged access paths to critical assets. Blast radius in the incident graph shows where an attacker could move next from a compromised entity, helping prioritise containment.
Remember: Blast radius = where they could go next.
- 6
Analyze relationships between entities by using Sentinel Graph
Microsoft Sentinel graph models security data as nodes and edges (users, devices, apps, data, permissions) across Defender, Entra, Purview and other sources. It powers blast radius, the hunting graph, attack paths and Purview data risk graphs, and supports custom graphs queried with Graph Query Language in the Defender portal. It's enabled with the Sentinel data lake.
Remember: Sentinel graph powers blast radius and the hunting graph.
Which table?
| Question | Table |
|---|---|
| What processes ran? | DeviceProcessEvents |
| What did a device connect to? | DeviceNetworkEvents |
| Who received this email? | EmailEvents |
| Who clicked this link? | UrlClickEvents |
| Where did this account sign in on-premises? | IdentityLogonEvents |
| What happened in a cloud app? | CloudAppEvents |
Try it
Hunt in sample Defender data. Try the examples, then edit them.
This interactive part needs JavaScript.
In the portal
- Advanced huntingMicrosoft Defender portal: Investigation & response > Hunting > Advanced hunting
- Threat analyticsMicrosoft Defender portal: Threat intelligence > Threat analytics
- GraphsMicrosoft Defender portal: Microsoft Sentinel > Graphs
Key terms
Click a card to see the definition.
Check your understanding
5 questions. Score 80% or more and these skills are marked as confident in your SC-200 study plan.
Which table shows processes launched on devices?
Process creation events.
Which table shows who clicked a URL in email?
Safe Links click data.
Which is faster for matching whole words?
has uses the term index.
What shows where an attacker could move from a compromised account?
Graph-based attacker paths.
How long does Advanced Hunting keep raw data by default?
30 days of data.
Sources
- Microsoft Learn: Advanced hunting overview
- Microsoft Learn: Advanced hunting schema tables
- Microsoft Learn: Threat analytics
- Microsoft Learn: What is Microsoft Sentinel graph?
- Microsoft Learn: KQL best practices
Facts in this lesson are from Microsoft Learn. This site isn't affiliated with Microsoft.