Microsoft Sentinel Analytic Rules
cloudbrothers.infoAzure Sentinel RepoToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

Theom - Shadow DB with atypical accesses

Back
Id02bff937-ca52-4f52-a9cd-b826f8602694
RulenameTheom - 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)”
SeverityHigh
Required data connectorsTheom
KindScheduled
Query frequency5m
Query period5m
Trigger threshold0
Trigger operatorgt
Source Urihttps://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0036_Shadow_DB_with_atypical_accesses.yaml
Version1.0.0
Arm template02bff937-ca52-4f52-a9cd-b826f8602694.json
Deploy To Azure
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"
      }
    }
  ]
}