Firewall errors stateful anomaly on database

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊

Back to Content Index


This query batches of distinct SQL queries that failed with error codes that might indicate malicious attempts to gain illegitimate access to the data. When attacker attempts to scan or gain access to server protected by firewall, he will be blocked by firewall and fail with error code 40615. Thus, if we see a large number of logins with such error codes, this could indicate attempts to gain access.

Attribute Value
Type Analytic Rule
Solution Azure SQL Database solution for sentinel
ID 20f87813-3de0-4a9f-a8c0-6aaa3187be08
Severity Medium
Status Available
Kind Scheduled
Tactics InitialAccess
Techniques T1190
Required Connectors AzureSql
Source View on GitHub

Tables Used

This content item queries data from the following tables:

Table Selection Criteria Transformations Ingestion API Lake-Only
AzureDiagnostics 🔶 Category == "SQLSecurityAuditEvents" ? ?

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊

Back to Analytic Rules · Back to Azure SQL Database solution for sentinel