SQL Client Tools PowerShell Session Detection
Last updated on:
In this page
About the rule
Rule Type
Standard
Rule Description
This rule detects execution of a PowerShell code through the sqltoolsps.exe utility, which is included in the standard set of utilities supplied with the Microsoft SQL Server Management studio. Script blocks are not logged in this case, so this utility helps to bypass protection mechanisms based on the analysis of these logs.
Severity
Trouble
Rule Requirement
Criteria
Action1: actionname = "Process started" AND (PROCESSNAME endswith "\sqltoolsps.exe" OR PARENTPROCESSNAME endswith "\sqltoolsps.exe" OR ORIGINALFILENAME = "\sqltoolsps.exe") AND PARENTPROCESSNAME notendswith "\smss.exe" select Action1.HOSTNAME,Action1.MESSAGE,Action1.COMMANDLINE,Action1.FILE_NAME,Action1.PROCESSNAME,Action1.USERNAME,Action1.PARENTPROCESSNAME
Detection
Execution Mode
realtime
Log Sources
Windows
Author
Agro (@agro_sev) oscd.communitly
