YARA · ditekSHen detection
DITEKSHEN_INDICATOR_TOOL_Sqlrecon
Detects SQLRecon C# MS-SQL toolkit designed for offensive reconnaissance and post-exploitation
- Author
- ditekSHen
- Date
- 2020-11-06
- Modified
- 2024-09-25
- Score / Quality
- 75 / 75
What this rule detects
Detects SQLRecon C# MS-SQL toolkit designed for offensive reconnaissance and post-exploitation
Targets: Windows PE.
It defines 9 patterns (9 text, 0 hex, 0 regex).
Summary generated from the rule's metadata and condition.
Rule source
rule DITEKSHEN_INDICATOR_TOOL_Sqlrecon : FILE
{
meta:
= "Detects SQLRecon C# MS-SQL toolkit designed for offensive reconnaissance and post-exploitation"
= "ditekSHen"
= "ec91285b-690d-5fd3-b0fc-f8d72cbb7e15"
= "2020-11-06"
= "2024-09-25"
= "https://github.com/ditekshen/detection"
= "https://github.com/ditekshen/detection/blob/e76c93dcdedff04076380ffc60ea54e45b313635/yara/indicator_tools.yar#L1420-L1436"
= "https://github.com/ditekshen/detection/blob/e76c93dcdedff04076380ffc60ea54e45b313635/LICENSE.txt"
= "784dbc518cf9492557c9b3536256c4a9b03e4536cf7cee7e764b8009dd4686bb"
= 75
= 75
= "FILE"
strings:
$s1 = "ConvertDLLToSQLBytes" ascii
$s2 = "\\SQLRecon.pdb" ascii
$s3 = "GetAllSQLServerInfo" ascii
$s4 = "<GetMSSQLSPNs>b__" ascii
$s5 = "select 1; exec master..xp_cmdshell" wide
$s6 = "-> Command Execution" wide
$s7 = ";EXEC dbo.sp_add_jobstep @job_name =" wide
$s8 = "EXEC sp_drop_trusted_assembly 0x" wide
$s9 = "(&(sAMAccountType=805306368)(servicePrincipalName=MSSQL*))" wide
condition:
uint16( 0 ) == 0x5a4d and 5 of them
}
Strings (9 patterns)
| Identifier | Type | Value | Modifiers |
|---|---|---|---|
| $s1 | text | "ConvertDLLToSQLBytes" | ascii |
| $s2 | text | "\\SQLRecon.pdb" | ascii |
| $s3 | text | "GetAllSQLServerInfo" | ascii |
| $s4 | text | "<GetMSSQLSPNs>b__" | ascii |
| $s5 | text | "select 1; exec master..xp_cmdshell" | wide |
| $s6 | text | "-> Command Execution" | wide |
| $s7 | text | ";EXEC dbo.sp_add_jobstep @job_name =" | wide |
| $s8 | text | "EXEC sp_drop_trusted_assembly 0x" | wide |
| $s9 | text | "(&(sAMAccountType=805306368)(servicePrincipalName=MSSQL*))" | wide |
Condition
uint16( 0 ) == 0x5a4d and 5 of themIn plain words (Heuristic)
- The file must start with “MZ” — a Windows executable (PE).
- At least 5 patterns in the rule must match.
Test this rule in your browser
Drop a file to scan it with this rule using YARA-X compiled to WebAssembly. Nothing is uploaded.
References
Licence & attribution
Author: ditekSHen
Source repository: ditekSHen detection @ e76c93dcde
Licence: BSD 2-Clause License (repository licence)
Copyright notice: Copyright 2021 by ditekSHen (https://github.com/ditekshen/detection).
Mirrored via YARA Forge 20260927, which prefixes rule names with the source and adds normalised meta fields.
Rule id: ec91285b-690d-5fd3-b0fc-f8d72cbb7e15
Tags:FILE
Related rules
- Suspicious / huntingditekSHen detection· ditekSHen· 2023-08-22
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21
- Suspicious / huntingditekSHen detection· ditekSHen· 2021-01-21