KQL queries by data source and table
Each table is a data source in Microsoft Sentinel or Defender XDR advanced hunting. Pick a table to see every query that uses it, or browse by ATT&CK tactic instead.
Identity
- SigninLogs4
Microsoft Sentinel
Microsoft Entra ID interactive user sign-ins, with result codes, client app, location and risk.
- AuditLogs3
Microsoft Sentinel
Microsoft Entra ID directory audit — changes to users, groups, applications, roles and policies.
- DeviceLogonEvents1
Microsoft Defender XDR
Authentication and sign-in events observed on endpoints by Defender for Endpoint.
- IdentityQueryEvents1
Microsoft Defender XDR
LDAP, SAMR and DNS query events from Defender for Identity, for Active Directory reconnaissance.
Endpoint
Network
- OfficeActivity2
Microsoft Sentinel
Microsoft 365 unified audit log covering Exchange Online, SharePoint, OneDrive and Teams operations.
- EmailEvents1
Microsoft Defender XDR
Email flow, verdicts and delivery actions from Defender for Office 365.
- UrlClickEvents1
Microsoft Defender XDR
Safe Links URL click events from Defender for Office 365, including click-through decisions.