TheomAlerts_CL
| where customProps_RuleId_s == "TRIS0036" and (priority_s == "P1" or priority_s == "P2")
severity: High
queryFrequency: 5m
triggerOperator: gt
kind: Scheduled
alertDetailsOverride:
alertDescriptionFormat: |2
Summary: {{summary_s}}
Additional info: {{details_s}}
Please investigate further on Theom UI at {{deepLink_s}}
alertDisplayNameFormat: 'Theom Alert ID: {{id_s}} '
query: |
TheomAlerts_CL
| where customProps_RuleId_s == "TRIS0036" and (priority_s == "P1" or priority_s == "P2")
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0036_Shadow_DB_with_atypical_accesses.yaml
queryPeriod: 5m
status: Available
version: 1.0.0
name: Theom - Shadow DB with atypical accesses
requiredDataConnectors:
- dataTypes:
- TheomAlerts_CL
connectorId: Theom
eventGroupingSettings:
aggregationKind: AlertPerResult
entityMappings:
id: 02bff937-ca52-4f52-a9cd-b826f8602694
description: |
"Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0036 (Theom has observed shadow or clone databases/tables. Additionally, it has observed atypical accesses to these data stores. As per this requirement, use this information to apply data access control lists or access permissions and enforce data retention policies)"
triggerThreshold: 0
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"workspace": {
"type": "String"
}
},
"resources": [
{
"id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/02bff937-ca52-4f52-a9cd-b826f8602694')]",
"name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/02bff937-ca52-4f52-a9cd-b826f8602694')]",
"type": "Microsoft.OperationalInsights/workspaces/providers/alertRules",
"kind": "Scheduled",
"apiVersion": "2022-11-01-preview",
"properties": {
"displayName": "Theom - Shadow DB with atypical accesses",
"description": "\"Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0036 (Theom has observed shadow or clone databases/tables. Additionally, it has observed atypical accesses to these data stores. As per this requirement, use this information to apply data access control lists or access permissions and enforce data retention policies)\"\n",
"severity": "High",
"enabled": true,
"query": "TheomAlerts_CL\n | where customProps_RuleId_s == \"TRIS0036\" and (priority_s == \"P1\" or priority_s == \"P2\")\n",
"queryFrequency": "PT5M",
"queryPeriod": "PT5M",
"triggerOperator": "GreaterThan",
"triggerThreshold": 0,
"suppressionDuration": "PT1H",
"suppressionEnabled": false,
"alertRuleTemplateName": "02bff937-ca52-4f52-a9cd-b826f8602694",
"eventGroupingSettings": {
"aggregationKind": "AlertPerResult"
},
"alertDetailsOverride": {
"alertDisplayNameFormat": "Theom Alert ID: {{id_s}} ",
"alertDescriptionFormat": "\nSummary: {{summary_s}} \nAdditional info: {{details_s}}\nPlease investigate further on Theom UI at {{deepLink_s}}\n"
},
"customDetails": null,
"entityMappings": null,
"templateVersion": "1.0.0",
"status": "Available",
"OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0036_Shadow_DB_with_atypical_accesses.yaml"
}
}
]
}