MSSQL 服务帐户异常进程
编辑MSSQL 服务帐户异常进程
编辑识别使用 MSSQL 服务帐户执行的异常进程,这可能表明 SQL 实例遭到利用/入侵。攻击者可能会利用暴露的 MSSQL 实例进行初始访问或横向移动。
规则类型: eql
规则索引:
- logs-endpoint.events.process-*
严重性: 低
风险评分: 21
运行频率: 5 分钟
搜索索引自: now-9m (日期数学格式,另见 额外回溯时间
)
每次执行的最大告警数: 100
参考资料:
标签:
- 域:端点
- 操作系统:Windows
- 用例:威胁检测
- 战术:横向移动
- 战术:持久化
- 数据源:Elastic Defend
- 规则类型:BBR
版本: 4
规则作者:
- Elastic
规则许可证: Elastic License v2
规则查询
编辑process where event.type == "start" and host.os.type == "windows" and user.name : ( "SQLSERVERAGENT", "SQLAGENT$*", "MSSQLSERVER", "MSSQL$*", "MSSQLServerOLAPService", "ReportServer*", "MsDtsServer150", "MSSQLFDLauncher*", "SQLServer2005SQLBrowserUser$*", "SQLWriter", "winmgmt" ) and user.domain : "NT SERVICE" and not ( ( process.name : ( "sqlceip.exe", "sqlservr.exe", "sqlagent.exe", "msmdsrv.exe", "ReportingServicesService.exe", "MsDtsSrvr.exe", "sqlbrowser.exe", "DTExec.exe", "SQLPS.exe", "fdhost.exe", "fdlauncher.exe", "SqlDumper.exe", "sqlsqm.exe", "DatabaseMail.exe", "ISServerExec.exe", "Microsoft.ReportingServices.Portal.WebHost.exe", "bcp.exe", "SQLCMD.exe", "DatabaseMail.exe" ) or process.executable : ( "?:\\Windows\\System32\\wermgr.exe", "?:\\Windows\\System32\\conhost.exe", "?:\\Windows\\System32\\WerFault.exe" ) ) and ( process.code_signature.subject_name : ("Microsoft Corporation", "Microsoft Windows") and process.code_signature.trusted == true ) ) and not ( (process.name : "cmd.exe" and process.parent.name : "sqlservr.exe") or (process.name : "cmd.exe" and process.parent.name : "forfiles.exe" and process.command_line : "/c echo *") )
框架: MITRE ATT&CKTM
-
战术
- 名称:横向移动
- ID:TA0008
- 参考网址:https://attack.mitre.org/tactics/TA0008/
-
技术
- 名称:远程服务利用
- ID:T1210
- 参考网址:https://attack.mitre.org/techniques/T1210/
-
战术
- 名称:持久化
- ID:TA0003
- 参考网址:https://attack.mitre.org/tactics/TA0003/
-
技术
- 名称:服务器软件组件
- ID:T1505
- 参考网址:https://attack.mitre.org/techniques/T1505/
-
子技术
- 名称:SQL 存储过程
- ID:T1505.001
- 参考网址:https://attack.mitre.org/techniques/T1505/001/