Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊
This query combines different SQL alerts with CommonSecurityLogs and AuditLogs helping analysts /investigate any possible SQL related attacks faster thus reducing Mean Time To Respond
| Attribute | Value |
|---|---|
| Type | Hunting Query |
| Solution | GitHub Only |
| ID | dc5adcc9-70ab-4fba-8690-f57767e8ca02 |
| Tactics | InitialAccess, Impact |
| Techniques | T1190, T1078 |
| Required Connectors | AzureSecurityCenter, PaloAltoNetworks, AzureActiveDirectory |
| Source | [View on GitHub](https://github.com/Azure/Azure-Sentinel/blob/master/Hunting Queries/MultipleDataSources/SQLAlertCorrelationwithCommonSecurityLogsandAuditLogs.yaml) |
This content item queries data from the following tables:
| Table | Selection Criteria | Transformations | Ingestion API | Lake-Only |
|---|---|---|---|---|
AuditLogs |
LoggedByService == "Core Directory" |
✓ | ✗ | ✓ |
CommonSecurityLog |
Activity == "TRAFFIC"DeviceAction != "deny"DeviceVendor == "Palo Alto Networks" |
✓ | ✓ | ✓ |
SecurityAlert |
AlertName has_any "Potential SQL Injection" |
✓ | ✗ | ✓ |
The following connectors provide data for this content item:
Solutions: Common Event Format, Microsoft Entra ID, VirtualMetric DataStream
Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊