MFA Failures

# --- Query Metadata ---
# Human-readable name for the query. Will be displayed as the title.
name: MFA Failures

# Description of what the query does and its purpose.
description: Displays the count of MFA authentication failures caused by service errors or user not being enrolled. A sudden spike in these errors may indicate a service incident requiring immediate investigation and response.

# The author or team that created the query.
author: CrowdStrike

# The required log sources to run this query successfully in Next-Gen SIEM.
# This will be displayed in the UI to inform the user.
log_sources:
  - Identity

# The CrowdStrike modules required to run this query.
cs_required_modules:
  - Identity

# Tags for filtering and categorization.
# Include relevant techniques, tactics, or platforms.
tags:
  - Monitoring

# --- Query Content ---
# The actual CrowdStrike Query Language (CQL) code.
# Using the YAML block scalar `|` allows for multi-line strings.
cql: |
  #repo=base_sensor #event_simpleName=IdpPolicy*RuleMatch
  | in(field=cid, values=[?SelectedCid])
  | match(file="aid_master_main.csv", field=[cid, aid])
  // Filters
  | in(field=MachineDomain, values=[?SelectedDomain])
  | case {
    IdpPolicyMfaStatus=128 | MfaError:="User Not Enrolled";
    IdpPolicyMfaStatus=256 | MfaError:="Service Error";
    *;
  }
  | timeChart(series=MfaError)