Lab: Splunk β Log Ingestion and SOC Alert Triage
π¬ Lab Practical β CSF & NS Practical 5 | Est. time: 4 hrs
π― Objective
Ingest Windows Security event logs into Splunk Free, write SPL queries to detect brute force and account creation, triage a simulated alert.
π SPL Queries to Write
# 1. Failed logins count
index=main EventCode=4625 | stats count
# 2. Failed logins by source IP
index=main EventCode=4625 | stats count by src_ip | sort -count
# 3. Timeline of failed logins
index=main EventCode=4625 | timechart count
# 4. New accounts created
index=main EventCode=4720 | table _time, TargetUserName
# 5. Successful login after failures
index=main EventCode=4624 src_ip="<suspicious_ip>"π Observation Questions
- Event ID 4625 with Logon Type 3 vs Type 10 β whatβs the difference in attack method?
- If confirmed brute-force true positive, what immediate containment steps should Tier 1 take?
π Related
- Splunk | SPL Cheatsheet β‘