Skip to content

YARA · ditekSHen detection

DITEKSHEN_INDICATOR_TOOL_Sqlrecon

Detects SQLRecon C# MS-SQL toolkit designed for offensive reconnaissance and post-exploitation

Suspicious / huntingditekSHen detectionBSD 2-Clause LicenseCompiles with YARA-X
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

indicator-tool-sqlrecon.yarBSD 2-Clause License
rule DITEKSHEN_INDICATOR_TOOL_Sqlrecon : FILE
{
	meta:
		description = "Detects SQLRecon C# MS-SQL toolkit designed for offensive reconnaissance and post-exploitation"
		author = "ditekSHen"
		id = "ec91285b-690d-5fd3-b0fc-f8d72cbb7e15"
		date = "2020-11-06"
		modified = "2024-09-25"
		reference = "https://github.com/ditekshen/detection"
		source_url = "https://github.com/ditekshen/detection/blob/e76c93dcdedff04076380ffc60ea54e45b313635/yara/indicator_tools.yar#L1420-L1436"
		license_url = "https://github.com/ditekshen/detection/blob/e76c93dcdedff04076380ffc60ea54e45b313635/LICENSE.txt"
		logic_hash = "784dbc518cf9492557c9b3536256c4a9b03e4536cf7cee7e764b8009dd4686bb"
		score = 75
		quality = 75
		tags = "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)

IdentifierTypeValueModifiers
$s1text"ConvertDLLToSQLBytes"ascii
$s2text"\\SQLRecon.pdb"ascii
$s3text"GetAllSQLServerInfo"ascii
$s4text"<GetMSSQLSPNs>b__"ascii
$s5text"select 1; exec master..xp_cmdshell"wide
$s6text"-> Command Execution"wide
$s7text";EXEC dbo.sp_add_jobstep @job_name ="wide
$s8text"EXEC sp_drop_trusted_assembly 0x"wide
$s9text"(&(sAMAccountType=805306368)(servicePrincipalName=MSSQL*))"wide

Condition

uint16( 0 ) == 0x5a4d and 5 of them

In 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.

Drop a file here or click to chooseScanned locally with YARA-X. Files up to 200 MB.

Open in editor

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).

Original rule

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