Techniques › T1505.001 › AN0511
AN0511 Analytic 0511
Windows · attack.mitre.org · ATT&CK Enterprise v19.2
<p>Creation or modification of stored procedures invoking xp_cmdshell or CLR assemblies for command execution and persistence.</p>
- Detects
- T1505.001 SQL Stored Procedures
- Part of
- DET0181 Detection Strategy for SQL Stored Procedures Abuse via T1505.001
Log sources and channels
Exactly as MITRE states them in x_mitre_log_source_references. Where a channel is vague, it is vague in the source; kevmap does not tidy it.
| Log source | Channel | Data component |
|---|---|---|
| WinEventLog:Application | Stored procedure creation, modification, or xp_cmdshell invocation via SQL logs or SQL Server auditing | DC0029 Script Execution |
| WinEventLog:Sysmon | EventCode=1 | DC0032 Process Creation |
| WinEventLog:Application | CLR Assembly creation, loading, or modification logs via MSSQL CLR integration | DC0016 Module Load |
Mutable elements
Parameters MITRE marks as environment-specific. These are the knobs you are expected to tune; they are why an analytic is not a rule.
| Field | Description |
|---|---|
xp_cmdshell_invocation_threshold | Adjust if legitimate procedures use xp_cmdshell often in environment |
CLRAssemblyNameWhitelist | Organization-defined whitelist of legitimate CLR assemblies |
TimeWindow | Tune time window to correlate stored procedure creation with process execution |