Skip to content

Siemphony is in beta and still being built. What ships today, and what does not.

Siemphony’s repertoire

Database client launched by a script host or Office parent

Siemphony@siemphonymediumT1213.006unverified
Matches execution of a command-line database client — the SQL Server, MySQL, PostgreSQL, MongoDB, Oracle and SQLite tools — when its parent is one of the processes MITRE calls out in this analytic as an odd launcher: explorer.exe (an interactive double-click rather than automation), a script host, or an Office application. Both halves sit on a single field each so the rule stays a flat AND and renders in every backend. cmd.exe is deliberately absent from the parent list: it is the normal path for scheduled backup and ETL batch jobs, and including it would drown the rule. The analytic's full behaviour is a correlation — client execution, then a .sql/.bak/.csv write, then an outbound transfer above MaxTransferVolume — which Sigma cannot express across three log sources with a time window, so this is the execution precursor only. UNVERIFIED AS AUTHORED — derived from MITRE ATT&CK DET0242, not hand-written and not tested by its author. Any lab result is on this rule's own page.Full description

The detection

The 4 SIEM queries below are previews produced by Siemphony’s own translator, not pySigma, and none has been executed against a real backend — review before you deploy.

detection.yml

Sentinel · KQL

Run this as a search.

DeviceProcessEvents| where ((FolderPath endswith "\\sqlcmd.exe" or FolderPath endswith "\\osql.exe" or FolderPath endswith "\\isql.exe" or FolderPath endswith "\\bcp.exe" or FolderPath endswith "\\sqlps.exe" or FolderPath endswith "\\sqlplus.exe" or FolderPath endswith "\\mysql.exe" or FolderPath endswith "\\mysqldump.exe" or FolderPath endswith "\\psql.exe" or FolderPath endswith "\\pg_dump.exe" or FolderPath endswith "\\mongo.exe" or FolderPath endswith "\\mongosh.exe" or FolderPath endswith "\\mongodump.exe" or FolderPath endswith "\\sqlite3.exe") and (InitiatingProcessFolderPath endswith "\\explorer.exe" or InitiatingProcessFolderPath endswith "\\powershell.exe" or InitiatingProcessFolderPath endswith "\\pwsh.exe" or InitiatingProcessFolderPath endswith "\\wscript.exe" or InitiatingProcessFolderPath endswith "\\cscript.exe" or InitiatingProcessFolderPath endswith "\\mshta.exe" or InitiatingProcessFolderPath endswith "\\rundll32.exe" or InitiatingProcessFolderPath endswith "\\winword.exe" or InitiatingProcessFolderPath endswith "\\excel.exe" or InitiatingProcessFolderPath endswith "\\outlook.exe"))

Splunk · SPL

Run this as a search.

index=* ((Image="*\\sqlcmd.exe" OR Image="*\\osql.exe" OR Image="*\\isql.exe" OR Image="*\\bcp.exe" OR Image="*\\sqlps.exe" OR Image="*\\sqlplus.exe" OR Image="*\\mysql.exe" OR Image="*\\mysqldump.exe" OR Image="*\\psql.exe" OR Image="*\\pg_dump.exe" OR Image="*\\mongo.exe" OR Image="*\\mongosh.exe" OR Image="*\\mongodump.exe" OR Image="*\\sqlite3.exe") AND (ParentImage="*\\explorer.exe" OR ParentImage="*\\powershell.exe" OR ParentImage="*\\pwsh.exe" OR ParentImage="*\\wscript.exe" OR ParentImage="*\\cscript.exe" OR ParentImage="*\\mshta.exe" OR ParentImage="*\\rundll32.exe" OR ParentImage="*\\winword.exe" OR ParentImage="*\\excel.exe" OR ParentImage="*\\outlook.exe"))

Elastic · ES|QL

Run this as a search.

FROM logs-*| WHERE ((TO_LOWER(process.executable) LIKE "*\\\\sqlcmd.exe" OR TO_LOWER(process.executable) LIKE "*\\\\osql.exe" OR TO_LOWER(process.executable) LIKE "*\\\\isql.exe" OR TO_LOWER(process.executable) LIKE "*\\\\bcp.exe" OR TO_LOWER(process.executable) LIKE "*\\\\sqlps.exe" OR TO_LOWER(process.executable) LIKE "*\\\\sqlplus.exe" OR TO_LOWER(process.executable) LIKE "*\\\\mysql.exe" OR TO_LOWER(process.executable) LIKE "*\\\\mysqldump.exe" OR TO_LOWER(process.executable) LIKE "*\\\\psql.exe" OR TO_LOWER(process.executable) LIKE "*\\\\pg_dump.exe" OR TO_LOWER(process.executable) LIKE "*\\\\mongo.exe" OR TO_LOWER(process.executable) LIKE "*\\\\mongosh.exe" OR TO_LOWER(process.executable) LIKE "*\\\\mongodump.exe" OR TO_LOWER(process.executable) LIKE "*\\\\sqlite3.exe") AND (TO_LOWER(process.parent.executable) LIKE "*\\\\explorer.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\powershell.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\pwsh.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\wscript.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\cscript.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\mshta.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\rundll32.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\winword.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\excel.exe" OR TO_LOWER(process.parent.executable) LIKE "*\\\\outlook.exe"))

Wazuh · XML rule

Deploy to your manager — this is a rule, not a search.

<group name="sigma,windows,process_creation,">  <!-- Rule ids must be unique on your manager; 100000+ is the user range. -->  <rule id="100000" level="7">    <!-- Set <if_sid> to the decoder/base rule for windows so this only evaluates relevant events. -->    <field name="Image" type="pcre2">(?i)(\\sqlcmd\.exe$|\\osql\.exe$|\\isql\.exe$|\\bcp\.exe$|\\sqlps\.exe$|\\sqlplus\.exe$|\\mysql\.exe$|\\mysqldump\.exe$|\\psql\.exe$|\\pg_dump\.exe$|\\mongo\.exe$|\\mongosh\.exe$|\\mongodump\.exe$|\\sqlite3\.exe$)</field>    <field name="ParentImage" type="pcre2">(?i)(\\explorer\.exe$|\\powershell\.exe$|\\pwsh\.exe$|\\wscript\.exe$|\\cscript\.exe$|\\mshta\.exe$|\\rundll32\.exe$|\\winword\.exe$|\\excel\.exe$|\\outlook\.exe$)</field>    <description>Database client launched by a script host or Office parent</description>    <mitre>      <id>T1213.006</id>    </mitre>  </rule></group>

Verdicts · reactions · comments

Community

Verdicts from engineers who actually deployed it, and the conversation around it.

Log in to react
Not yet reported on

Nobody has run this in a real environment and said what happened.

Verdicts from engineers who deployed it

0 cast

No verdicts reported yet. The first one is worth more than the tenth — say what you ran it against.

Log in to report a verdict.

Log in to join the discussion.

No comments yet. Someone who deploys this will have something to say about it.