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 large datastore value

Back
Id7cf83fce-276a-4b12-a876-7b1bc0683cd6
RulenameTheom - Shadow DB large datastore value
Description“Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0035 (Theom has observed shadow (or clone) databases/tables with large financial value. 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/TRIS0035_Shadow_DB_large_datastore_value.yaml
Version1.0.0
Arm template7cf83fce-276a-4b12-a876-7b1bc0683cd6.json
Deploy To Azure
TheomAlerts_CL
  | where customProps_RuleId_s == "TRIS0035" and (priority_s == "P1" or priority_s == "P2")
triggerOperator: gt
version: 1.0.0
query: |
  TheomAlerts_CL
    | where customProps_RuleId_s == "TRIS0035" and (priority_s == "P1" or priority_s == "P2")  
status: Available
entityMappings: 
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0035_Shadow_DB_large_datastore_value.yaml
queryFrequency: 5m
requiredDataConnectors:
- connectorId: Theom
  dataTypes:
  - TheomAlerts_CL
eventGroupingSettings:
  aggregationKind: AlertPerResult
name: Theom - Shadow DB large datastore value
queryPeriod: 5m
severity: High
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}} '
id: 7cf83fce-276a-4b12-a876-7b1bc0683cd6
description: |
    "Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0035 (Theom has observed shadow (or clone) databases/tables with large financial value. 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/7cf83fce-276a-4b12-a876-7b1bc0683cd6')]",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/7cf83fce-276a-4b12-a876-7b1bc0683cd6')]",
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules",
      "kind": "Scheduled",
      "apiVersion": "2022-11-01-preview",
      "properties": {
        "displayName": "Theom - Shadow DB large datastore value",
        "description": "\"Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0035 (Theom has observed shadow (or clone) databases/tables with large financial value. 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 == \"TRIS0035\" and (priority_s == \"P1\" or priority_s == \"P2\")\n",
        "queryFrequency": "PT5M",
        "queryPeriod": "PT5M",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0,
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "alertRuleTemplateName": "7cf83fce-276a-4b12-a876-7b1bc0683cd6",
        "eventGroupingSettings": {
          "aggregationKind": "AlertPerResult"
        },
        "alertDetailsOverride": {
          "alertDescriptionFormat": "\nSummary: {{summary_s}}  \nAdditional info: {{details_s}}\nPlease investigate further on Theom UI at {{deepLink_s}}\n",
          "alertDisplayNameFormat": "Theom Alert ID: {{id_s}} "
        },
        "customDetails": null,
        "entityMappings": null,
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0035_Shadow_DB_large_datastore_value.yaml",
        "templateVersion": "1.0.0",
        "status": "Available"
      }
    }
  ]
}