Vendor: Microsoft

Product: Microsoft SQL Server

Rules	Models	MITRE TTPs	Event Types	Parsers
7	2	3	7	7

Use-Case	Event Types/Parsers	MITRE TTP	Content
Compromised Credentials	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1078 - Valid Accounts T1133 - External Remote Services	3 Rules 2 Models
Data Access	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1078 - Valid Accounts	1 Rules
Evasion	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1090.003 - Proxy: Multi-hop Proxy	1 Rules
Malware	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1090.003 - Proxy: Multi-hop Proxy	1 Rules
Privilege Abuse	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1078 - Valid Accounts	1 Rules
Privileged Activity	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1078 - Valid Accounts	1 Rules
Ransomware	database-access ↳ cef-mssql-database-access database-activity-failed ↳ mssql-database-query-2 database-delete ↳ cef-microsoft-database-delete database-failed-login ↳ cef-microsoft-database-failed-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ mssql-database-login-1 ↳ s-microsoft-database-login database-login ↳ s-database-login-18454 ↳ s-database-login-18453 ↳ cef-syslog-microsoft-db-login ↳ cef-syslog-microsoft-db-impersonate ↳ mssql-database-login ↳ cef-microsoft-database-login ↳ xml-mssql-database-login ↳ xml-mssql-database-login-1 ↳ cef-mssql-database-login ↳ s-microsoft-database-login database-query ↳ xml-mssql-database-login ↳ mssql-database-query-3 ↳ mssql-database-query-2 failed-app-login ↳ s-failed-app-login ↳ exalms-sqlserver-failed-login	T1078 - Valid Accounts	1 Rules

ATT&CK Matrix for Enterprise

Initial Access	Execution	Persistence	Privilege Escalation	Defense Evasion	Credential Access	Discovery	Lateral Movement	Collection	Command and Control	Exfiltration	Impact
External Remote Services Valid Accounts		External Remote Services Valid Accounts	Valid Accounts	Valid Accounts					Proxy: Multi-hop Proxy Proxy