All tables
Identity / Authentication and sign-in

SigninLogs

Interactive user sign-in events from Microsoft Entra ID including MFA, conditional access, and location

Recommendation

High-value events that need near-real-time detection, low-volume join targets, or high-value tables the lake cannot hold.

How the matrix works

C2 Authentication and credential use

Authentication and credential use, including non-interactive, service principal, managed identity, federated, VPN, NAC, and password vault access

ACSC

  • 2. Network device logsVPN and NAC
  • 3. Microsoft Domain Controller
  • 4. Active Directory (AD) and Domain Service security logs
  • 8. Cloud platform loggingEntra sign-in logs

CISA

  • 1. Identity, credential, and access management (ICAM)1b Track usage of credentials

MITRE data sources

  • User Account: Authentication
  • Logon Session: Logon Session Creation

T1 Near-real-time detection

Generic detections need near-real-time matching on single events.

Lake supported in the Azure Monitor table feature matrix

Fields detections use

High-value fields

TimeGeneratedUserPrincipalNameUserDisplayNameIPAddressLocationResultTypeResultDescriptionAppDisplayNameAppIdClientAppUsedDeviceDetailConditionalAccessStatusRiskLevelDuringSignInRiskLevelAggregatedRiskStateRiskDetailMfaDetailAuthenticationRequirementResourceDisplayNameResourceIdUserAgentCorrelationIdOriginalRequestIdHomeTenantIdResourceTenantId

Most used in public rules

  1. ResultType81
  2. TimeGenerated81
  3. UserPrincipalName70
  4. IPAddress53
  5. AppDisplayName45
  6. UserId29
  7. OperationName27
  8. Location22
  9. ResultDescription16
  10. UserType16
  11. CorrelationId14
  12. AppId12

Split hints

Rows to keep in Analytics with a split rule.

Keep failed sign-ins, risky sign-ins, MFA events, and all emergency access account sign-ins in Analytics. Replace the placeholders with the object IDs of your emergency access accounts.

(ResultType != "0" or RiskLevelDuringSignIn != "none" or ConditionalAccessStatus == "failure" or AuthenticationRequirement == "multiFactorAuthentication" or UserId in ("<emergency-account-object-id-1>", "<emergency-account-object-id-2>"))

Sources for this recommendation