Query: detect Detects when the MSSQL "xp_cmdshell" stored procedure is used to execute commands in logs
Matching passage: Sigma rule: Detects when the MSSQL "xp_cmdshell" stored procedure is used to execute commands. Logsource: windows / application. Rule: title: MSSQL XPCmdshell Suspicious Execution id: 7f103213-a04e-4d59-8261-213dddf22314 status: test description: Detects when the MSSQL "xp_cmdshell" stored procedure is used to execute commands references: - https://www.netspi.com/blog/technical/network-penetration-testing/sql-server-persistence-part-1-startup-stored-procedures/ - https://thedfirreport.com/2022/07/11/select-xmrig-from-sqlserver/ author: Nasreddine Bencherchali (Nextron Systems) date: 2022-07-12 modified: 2024-06-26 tags: - attack.execution logsource: product: windows service: application definition: 'Requirements: MSSQL audit policy to monitor for "xp_cmdshell" must be enabled in order to receive this event in the application log (Follow this tutorial https://dba.stackexchange.com/questions/103183/is-there-any-way-to-monitor-execution-of-xp-cmdshell-in-sql-server-2012)' detection: selection: Provider_Name|contains: MSSQL EventID: 33205 Data|contains|all: - object_name:xp_cmdshell - statement:EXEC condition: selection falsepositives: - Unknown level: high
Near-miss passage: Sigma rule: Detects execution of mshta.exe with file types that looks like they do not typically represent HTA (HTML Application) co. Logsource: windows / process_creation. Rule: title: MSHTA Execution with Suspicious File Extensions id: cc7abbd0-762b-41e3-8a26-57ad50d2eea3 status: test description: 'Detects execution of mshta.exe with file types that looks like they do not typically represent HTA (HTML Application) content, such as .png, .jpg, .zip, .pdf, and others, which are often polyglots. MSHTA is a legitimate Windows utility for executing HTML Applications containing VBScript or JScript. Threat actors often abuse this lolbin utility to download and execute malicious scripts disguised as benign files or hosted under misleading extensions to evade detection. ' references: - http://blog.sevagas.com/?Hacking-around-HTA-files - https://0x00sec.org/t/clientside-exploitation-in-2018-how-pentesting-has-changed/7356 - https://learn.microsoft.com/en-us/previous-versions/dotnet/framework/data/xml/xslt/xslt-stylesheet-scripting-using-msxsl-script - https://medium.com/tsscyber/pentesting-and-hta-bypassing-powershell-constrained-language-mode-53a42856c997 - https://twitter.com/mattifestation/status/1326228491302563846 - https://www.virustotal.com/gui/file/c1f27d9795a2eba630db8a043580a0761798f06370fb1317067805f8a845b00c author: Diego Perez (@darkquassar), Markus Neis, Swisscom (Improve Rule), Swachchhanda Shrawan Poudel (Nextron Systems) date: 2019-02-22 modified: 2025-05-12 tags: - attack.stealth - attack.t1140 - attack.t1218.005 - attack.execution - attack.t1059.007 - cve.2020-1599 logsource: category: process_creation product: windows detection: selection_img: - Image|endswith: \mshta.exe - OriginalFileName: mshta.exe selection_cli: CommandLine|contains: - .7z - .avi - .bat - .bmp - .conf - .csv - .dll - .doc - .gif - .gz - .ini - .jpe - .jpg - .json - .lnk - .log - .mkv - .mp3 - .mp4 - .pdf - .png - .ppt - .rar - .rtf - .svg - .tar - .tmp - .txt - .xls - .xml - .yaml - .yml - .zip - vbscript condition: all of selection_* falsepositives: - False positives depend on scripts and administrative tools used in the monitored environment level: high