Splunksplunkcorrelationincident-responseinvestigationproduction-ready
Correlation Search Patterns
SPL queries that correlate events across multiple data sources for incident investigation and root cause analysis.
title: "Correlation Search Patterns" description: "SPL queries that correlate events across multiple data sources for incident investigation and root cause analysis." category: "Splunk" language: "spl" tags: ["splunk", "correlation", "incident-response", "investigation", "production-ready"] createdAt: "2025-03-01" updatedAt: "2025-03-20"
Overview
Correlation searches that join events across multiple indexes and source types to establish causality between infrastructure changes, deployments, and application errors. These are essential for reducing mean time to resolution (MTTR) during incidents.
Code
index=application status>=500
| join type=left host [search index=infrastructure cpu_pct>90]
| where isnotnull(cpu_pct)Notes
- Use
transactionfor grouping events by session/request ID across sources joinwith time window correlation identifies causal relationships (deploy then errors)- Keep correlation windows tight (5-15 min) to reduce false positives
dc()(distinct count) helps identify distributed vs. single-source attack patterns- Schedule these as saved searches for automatic incident enrichment