--- Identify common false positive patterns
index=notable rule_name="Suspicious PowerShell Execution" status_label="Resolved - False Positive"
earliest=-90d
| stats count by src, dest, user, CommandLine
| sort - count
| head 20
--- Reveals: SCCM client generating 80% of false positives
Apply tuning:
--- Original rule (generating false positives)
index=sysmon EventCode=1 Image="*\\powershell.exe"
(CommandLine="*-enc*" OR CommandLine="*-encodedcommand*" OR CommandLine="*invoke-expression*")
| where count > 0
--- Tuned rule (excluding known legitimate sources)
index=sysmon EventCode=1 Image="*\\powershell.exe"
(CommandLine="*-enc*" OR CommandLine="*-encodedcommand*" OR CommandLine="*invoke-expression*")
NOT [| inputlookup powershell_whitelist.csv | fields CommandLine_pattern]
NOT (ParentImage="*\\ccmexec.exe" OR ParentImage="*\\sccm*")
NOT (User="SYSTEM" AND ParentImage="*\\services.exe" AND
CommandLine="*Microsoft\\ConfigMgr*")
| where count > 0
Document tuning decisions:
rule_name: Suspicious PowerShell Execution
tuning_date: 2024-03-15
original_fp_rate: 78%
tuned_fp_rate: 22%
exclusions_added:
- ParentImage containing ccmexec.exe (SCCM client)
- User=SYSTEM with ConfigMgr in CommandLine
- Scheduled task: Windows Update PowerShell module
alerts_reduced: ~180/day eliminated
detection_impact: None — exclusions verified against ATT&CK test cases
approved_by: detection_engineering_lead
Step 4: Implement Alert Consolidation
Group related alerts into single incidents:
--- Consolidate alerts by source IP within time window
index=notable earliest=-1h
| sort _time
| dedup src, rule_name span=300
| stats count AS alert_count, values(rule_name) AS related_rules,
earliest(_time) AS first_alert, latest(_time) AS last_alert
by src
| where alert_count > 3
| eval consolidated_alert = src." triggered ".alert_count." related alerts: ".mvjoin(related_rules, ", ")
Splunk ES Notable Event Suppression:
--- Suppress duplicate alerts for the same source/dest pair within 1 hour
| notable
| dedup src, dest, rule_name span=3600
Step 5: Implement Tiered Alert Routing
Route alerts based on confidence and severity:
ALERT ROUTING STRATEGY
━━━━━━━━━━━━━━━━━━━━━
Tier 1 (Automated):
- Risk score < 30: Auto-close with enrichment data logged
- Known false positive patterns: Auto-suppress (reviewed quarterly)
- Informational alerts: Route to dashboard only (no queue)
Tier 2 (Analyst Review):
- Risk score 30-75: Standard triage queue
- Medium confidence alerts: Analyst decision required
- Enriched with automated context (VT, AbuseIPDB, asset info)
Tier 3 (Priority Investigation):
- Risk score > 75: Immediate investigation
- Deception alerts: Auto-escalate (zero false positive)
- Known malware detection: Auto-contain + analyst review
Implement in Splunk:
index=notable
| eval routing = case(
urgency="critical" OR source="deception", "TIER3_IMMEDIATE",
urgency="high" AND risk_score > 75, "TIER3_IMMEDIATE",
urgency="high" OR urgency="medium", "TIER2_STANDARD",
urgency="low" AND fp_rate > 80, "TIER1_AUTO_CLOSE",
1=1, "TIER2_STANDARD"
)
| where routing != "TIER1_AUTO_CLOSE" --- Auto-closed alerts removed from queue
Step 6: Measure Improvement and Maintain
Track alert fatigue metrics over time:
--- Weekly alert quality trend
index=notable earliest=-90d
| bin _time span=1w
| stats count AS total,
sum(eval(if(status_label="Resolved - True Positive", 1, 0))) AS tp,
sum(eval(if(status_label="Resolved - False Positive", 1, 0))) AS fp
by _time
| eval tp_rate = round(tp / total * 100, 1)
| eval fp_rate = round(fp / total * 100, 1)
| eval alerts_per_analyst = round(total / 42, 0) --- 6 analysts * 7 days
| table _time, total, tp, fp, tp_rate, fp_rate, alerts_per_analyst
Key Concepts
Term
Definition
Alert Fatigue
Cognitive overload from excessive alert volumes leading analysts to dismiss or ignore valid alerts
Risk-Based Alerting (RBA)
Detection approach aggregating risk contributions from multiple events before generating a single high-context alert
Signal-to-Noise Ratio
Ratio of true positive alerts to false positives — higher ratio indicates better alert quality
False Positive Rate
Percentage of alerts classified as benign after investigation — target <30% for production rules
Alert Consolidation
Grouping related alerts from the same source/campaign into a single investigation unit
Detection Tuning
Process of refining rule logic to exclude known benign patterns while maintaining true positive detection
Tools & Systems
Splunk ES Risk-Based Alerting: Framework converting individual detections into cumulative risk scores per entity
Splunk ES Adaptive Response: Actions that can auto-close, suppress, or route alerts based on enrichment results
Elastic Detection Rules: Built-in severity and risk score assignment with exception lists for tuning
Chronicle SOAR: Google's SOAR platform with automated alert deduplication and grouping capabilities