-
This project demonstrates a SOC detection engineering workflow focused on monitoring and investigating suspicious web activity using:
- Splunk SIEM
- Web server log analysis
- Sigma rules
- MITRE ATT&CK mapping
- Threat hunting techniques
- HTTP attack detection
-
The project simulates how SOC analysts and detection engineers investigate suspicious web activity and identify common web attack patterns.
-
Detect and investigate:
- SQL Injection attempts
- Cross-Site Scripting (XSS)
- Directory traversal attempts
- Web brute force attacks
- Suspicious User-Agent activity
- HTTP error spikes
- Reconnaissance and scanning activity
| Technology | Purpose |
|---|---|
| Splunk Free | SIEM platform |
| Web Server Logs | HTTP telemetry |
| SPL | Detection queries |
| Sigma | Portable detections |
| MITRE ATT&CK | Threat mapping |
| Technique | ID | Tactic |
|---|---|---|
| Exploit Public-Facing Application | T1190 | Initial Access |
| Brute Force | T1110 | Credential Access |
| Command and Scripting Interpreter | T1059 | Execution |
| Active Scanning | T1595 | Reconnaissance |
-
This project monitors for:
- Suspicious URL patterns
- SQL Injection keywords
- XSS payload indicators
- Excessive failed requests
- Directory traversal attempts
- Malicious User-Agents
- Authentication abuse
- HTTP error anomalies
index=main ("UNION SELECT" OR "SELECT * FROM" OR "' OR 1=1")
-
This project explores:
- Web attack detection
- HTTP telemetry analysis
- Threat hunting workflows
- Detection logic development
- Log analysis
- Security investigation methodology
title: SQL Injection Attempt Detection
description: Detects potential SQL Injection activity in web logs.
logsource:
category: webserver
detection:
selection:
cs-uri-query|contains:
- "UNION SELECT"
- "' OR 1=1"
- "SELECT * FROM"
condition: selection
level: high- Review suspicious HTTP requests
- Identify malicious patterns
- Analyze source behavior
- Investigate targeted endpoints
- Correlate attack indicators
- Escalate suspicious activity
-
Potential benign causes:
- Security testing
- Vulnerability scanners
- Developer testing
- Encoded URLs
- Search engine crawlers
- Splunk web log analysis
- Threat hunting
- Detection engineering
- HTTP telemetry analysis
- Sigma rule creation
- ATT&CK mapping
- Web attack monitoring
- Security investigation workflows
-
Potential future enhancements:
- GeoIP correlation
- Threat intelligence integration
- Automated alerting
- Web attack dashboards
- IP reputation analysis
- WAF telemetry integration
- Active SOC detection engineering learning project focused on web attack monitoring and suspicious HTTP activity detection.





