Identity Protection - Average Cloud Response Time

# --- Query Metadata ---
# Human-readable name for the query. Will be displayed as the title.
name: Identity Protection - Average Cloud Response Time

# Description of what the query does and its purpose.
description: Average time (in seconds) the cloud service takes to resolve entity information (e.g., from SID/GUID). Latency above 3 seconds may cause intermittent issues; above 4 seconds can lead to recurring timeouts.

# 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=IdpTelemetryData
  | in(field=cid, values=[?SelectedCid])
  | match(file="aid_master_main.csv", field=[cid, aid])
  | in(field=MachineDomain, values=[?SelectedDomain])
  | IdpTelemetryObjectArrayV2=/{"_name":"IdpTelemetryObject","identifier":\["CloudFetcher\/CloudResponseTime"\],"statistics_features":\[{"_name":"IdpTelemetryObjectStatisticsFeatures","average":\["(?<CloudResponseTimeAverage>\d+)"\],"median":\["(?<CloudResponseTimeMedian>\d+)"\],"p95_value":\["(?<CloudResponseTimeP95_value>\d+)"\],"p99_value":\["(?<CloudResponseTimeP99_value>\d+)"\]}]}/
  | CloudResponseTimeAverage:=CloudResponseTimeAverage/10000000
  | timeChart(function=avg("CloudResponseTimeAverage"))