VMware ESXi - Multiple VMs stopped

Back


Id	5fe1af14-cd40-48ff-b581-3a12a1f90785
Rulename	VMware ESXi - Multiple VMs stopped
Description	Detects when multiple VMs ware stopped by user.
Severity	Medium
Tactics	Impact
Techniques	T1529
Required data connectors	VMwareESXi
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMWareESXi/Analytic Rules/ESXiMultipleVMStopped.yaml
Version	1.0.1
Arm template	5fe1af14-cd40-48ff-b581-3a12a1f90785.json

KQL

let threshold = 5;
VMwareESXi
| where SyslogMessage has ('VmPoweredOffEvent')
| extend SrcUsername = extract(@'\[info\]\s+\[(.*?)\]', 1, SyslogMessage)
| extend DstHostname = extract(@'\[\d+\]\s+\[(.*?)\s+on', 1, SyslogMessage)
| summarize st_vm = make_set(DstHostname,200) by SrcUsername, bin(TimeGenerated, 5m)
| where array_length(st_vm) > threshold
| extend hostname = iff(array_length(st_vm) > 0, st_vm[0], "")
| extend NTDomain = tostring(split(hostname, '\\', 0)[0]), Name = tostring(split(SrcUsername, '\\', 1)[0]), HostName = tostring(split(hostname, '.', 0)[0]), DnsDomain = tostring(split(SrcUsername, '\\', 1)[0])

YAML

version: 1.0.1
name: VMware ESXi - Multiple VMs stopped
severity: Medium
queryFrequency: 1h
kind: Scheduled
queryPeriod: 1h
description: |
    'Detects when multiple VMs ware stopped by user.'
query: |
  let threshold = 5;
  VMwareESXi
  | where SyslogMessage has ('VmPoweredOffEvent')
  | extend SrcUsername = extract(@'\[info\]\s+\[(.*?)\]', 1, SyslogMessage)
  | extend DstHostname = extract(@'\[\d+\]\s+\[(.*?)\s+on', 1, SyslogMessage)
  | summarize st_vm = make_set(DstHostname,200) by SrcUsername, bin(TimeGenerated, 5m)
  | where array_length(st_vm) > threshold
  | extend hostname = iff(array_length(st_vm) > 0, st_vm[0], "")
  | extend NTDomain = tostring(split(hostname, '\\', 0)[0]), Name = tostring(split(SrcUsername, '\\', 1)[0]), HostName = tostring(split(hostname, '.', 0)[0]), DnsDomain = tostring(split(SrcUsername, '\\', 1)[0])  
tactics:
- Impact
triggerOperator: gt
entityMappings:
- entityType: Account
  fieldMappings:
  - columnName: Name
    identifier: Name
  - columnName: DnsDomain
    identifier: DnsDomain
- entityType: Host
  fieldMappings:
  - columnName: HostName
    identifier: HostName
  - columnName: NTDomain
    identifier: NTDomain
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMWareESXi/Analytic Rules/ESXiMultipleVMStopped.yaml
requiredDataConnectors:
- connectorId: VMwareESXi
  dataTypes:
  - VMwareESXi
status: Available
relevantTechniques:
- T1529
id: 5fe1af14-cd40-48ff-b581-3a12a1f90785

ARM

{
  "$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/5fe1af14-cd40-48ff-b581-3a12a1f90785')]",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/5fe1af14-cd40-48ff-b581-3a12a1f90785')]",
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules",
      "kind": "Scheduled",
      "apiVersion": "2022-11-01-preview",
      "properties": {
        "displayName": "VMware ESXi - Multiple VMs stopped",
        "description": "'Detects when multiple VMs ware stopped by user.'\n",
        "severity": "Medium",
        "enabled": true,
        "query": "let threshold = 5;\nVMwareESXi\n| where SyslogMessage has ('VmPoweredOffEvent')\n| extend SrcUsername = extract(@'\\[info\\]\\s+\\[(.*?)\\]', 1, SyslogMessage)\n| extend DstHostname = extract(@'\\[\\d+\\]\\s+\\[(.*?)\\s+on', 1, SyslogMessage)\n| summarize st_vm = make_set(DstHostname,200) by SrcUsername, bin(TimeGenerated, 5m)\n| where array_length(st_vm) > threshold\n| extend hostname = iff(array_length(st_vm) > 0, st_vm[0], \"\")\n| extend NTDomain = tostring(split(hostname, '\\\\', 0)[0]), Name = tostring(split(SrcUsername, '\\\\', 1)[0]), HostName = tostring(split(hostname, '.', 0)[0]), DnsDomain = tostring(split(SrcUsername, '\\\\', 1)[0])\n",
        "queryFrequency": "PT1H",
        "queryPeriod": "PT1H",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0,
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "Impact"
        ],
        "techniques": [
          "T1529"
        ],
        "alertRuleTemplateName": "5fe1af14-cd40-48ff-b581-3a12a1f90785",
        "customDetails": null,
        "entityMappings": [
          {
            "fieldMappings": [
              {
                "columnName": "Name",
                "identifier": "Name"
              },
              {
                "columnName": "DnsDomain",
                "identifier": "DnsDomain"
              }
            ],
            "entityType": "Account"
          },
          {
            "fieldMappings": [
              {
                "columnName": "HostName",
                "identifier": "HostName"
              },
              {
                "columnName": "NTDomain",
                "identifier": "NTDomain"
              }
            ],
            "entityType": "Host"
          }
        ],
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMWareESXi/Analytic Rules/ESXiMultipleVMStopped.yaml",
        "templateVersion": "1.0.1",
        "status": "Available"
      }
    }
  ]
}