VMwareESXi
| where SyslogMessage has ('VmPoweredOffEvent')
| extend SrcUsername = extract(@'\[info\]\s+\[(.*?)\]', 1, SyslogMessage)
| extend DstHostname = extract(@'\[\d+\]\s+\[(.*?)\s+on', 1, SyslogMessage)
| extend HostCustomEntity = DstHostname, AccountCustomEntity = SrcUsername
version: 1.0.2
status: Available
queryPeriod: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMWareESXi/Analytic Rules/ESXiVMStopped.yaml
relevantTechniques:
- T1529
description: |
'Detects when VM was stopped.'
kind: Scheduled
name: VMware ESXi - VM stopped
queryFrequency: 1h
id: 43889f30-7bce-4d8a-93bb-29c9615ca8dd
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
tactics:
- Impact
triggerThreshold: 0
severity: Medium
query: |
VMwareESXi
| where SyslogMessage has ('VmPoweredOffEvent')
| extend SrcUsername = extract(@'\[info\]\s+\[(.*?)\]', 1, SyslogMessage)
| extend DstHostname = extract(@'\[\d+\]\s+\[(.*?)\s+on', 1, SyslogMessage)
| extend HostCustomEntity = DstHostname, AccountCustomEntity = SrcUsername
entityMappings:
- entityType: Host
fieldMappings:
- columnName: HostCustomEntity
identifier: FullName
- entityType: Account
fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
triggerOperator: gt