Utimaco ESKM - Burst of KMIP DESTROY operations by a single user

UtimacoESKMKmipServerLogs_CL
| where TimeGenerated > ago(10m)
| where Operation == "DESTROY"
| where Result == "SUCCESS"
| where isnotempty(User)
| summarize DestroyCount = count(), StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), ObjectTypes = make_set(ObjectType, 25), UUIDs = make_set(UUID, 100), SourceIPs = make_set(IP, 25) by User
| where DestroyCount >= 20
| extend AccountCustomEntity = User

name: Utimaco ESKM - Burst of KMIP DESTROY operations by a single user
triggerOperator: gt
query: |
  UtimacoESKMKmipServerLogs_CL
  | where TimeGenerated > ago(10m)
  | where Operation == "DESTROY"
  | where Result == "SUCCESS"
  | where isnotempty(User)
  | summarize DestroyCount = count(), StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), ObjectTypes = make_set(ObjectType, 25), UUIDs = make_set(UUID, 100), SourceIPs = make_set(IP, 25) by User
  | where DestroyCount >= 20
  | extend AccountCustomEntity = User
queryFrequency: 10m
description: |
  Identifies a single KMIP user issuing 20 or more DESTROY operations within 10 minutes on Utimaco ESKM. May indicate mass key/object deletion, insider sabotage, or ransomware-style cryptographic-material destruction.
id: 9b1a3b3e-7e16-4a3b-8a8f-7f1f2b1c0a03
triggerThreshold: 0
queryPeriod: 10m
version: 1.0.0
kind: Scheduled
status: Available
severity: High
requiredDataConnectors:
- connectorId: UtimacoESKMConnector
  dataTypes:
  - UtimacoESKMKmipServerLogs_CL
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Utimaco%20Enterprise%20Secure%20Key%20Manager/Analytic%20Rules/UtimacoESKM_DestroyBurst.yaml
relevantTechniques:
- T1485
tactics:
- Impact
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
  entityType: Account

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "apiVersion": "2024-01-01-preview",
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/9b1a3b3e-7e16-4a3b-8a8f-7f1f2b1c0a03')]",
      "kind": "Scheduled",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/9b1a3b3e-7e16-4a3b-8a8f-7f1f2b1c0a03')]",
      "properties": {
        "alertRuleTemplateName": "9b1a3b3e-7e16-4a3b-8a8f-7f1f2b1c0a03",
        "customDetails": null,
        "description": "Identifies a single KMIP user issuing 20 or more DESTROY operations within 10 minutes on Utimaco ESKM. May indicate mass key/object deletion, insider sabotage, or ransomware-style cryptographic-material destruction.\n",
        "displayName": "Utimaco ESKM - Burst of KMIP DESTROY operations by a single user",
        "enabled": true,
        "entityMappings": [
          {
            "entityType": "Account",
            "fieldMappings": [
              {
                "columnName": "AccountCustomEntity",
                "identifier": "Name"
              }
            ]
          }
        ],
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Utimaco%20Enterprise%20Secure%20Key%20Manager/Analytic%20Rules/UtimacoESKM_DestroyBurst.yaml",
        "query": "UtimacoESKMKmipServerLogs_CL\n| where TimeGenerated > ago(10m)\n| where Operation == \"DESTROY\"\n| where Result == \"SUCCESS\"\n| where isnotempty(User)\n| summarize DestroyCount = count(), StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), ObjectTypes = make_set(ObjectType, 25), UUIDs = make_set(UUID, 100), SourceIPs = make_set(IP, 25) by User\n| where DestroyCount >= 20\n| extend AccountCustomEntity = User\n",
        "queryFrequency": "PT10M",
        "queryPeriod": "PT10M",
        "severity": "High",
        "status": "Available",
        "subTechniques": [],
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "Impact"
        ],
        "techniques": [
          "T1485"
        ],
        "templateVersion": "1.0.0",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0
      },
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
    }
  ]
}