VMware vCenter - Root login

let p_lookback = 14d;
let t_lookback = 1h;
let root_ips = vCenter
| where TimeGenerated between (ago(p_lookback) .. ago(t_lookback))
| where EventType has_all ('UserLoginSessionEvent', 'root', 'logged in')
| summarize make_set(SourceIP,128);
vCenter
| where TimeGenerated > ago(t_lookback)
| where EventType   has_all ('UserLoginSessionEvent', 'root', 'logged in')
| where SourceIP   !in (root_ips)

requiredDataConnectors:
- connectorId: vCenter
  dataTypes:
  - vCenter
triggerOperator: gt
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMware vCenter/Analytic Rules/vCenterRootLogin.yaml
version: 1.0.0
status: Available
queryPeriod: 14d
severity: High
relevantTechniques:
- T1078
tactics:
- InitialAccess
- PrivilegeEscalation
kind: Scheduled
queryFrequency: 1h
description: |
    'Detects when root user login from uncommon IP address.'
query: |
  let p_lookback = 14d;
  let t_lookback = 1h;
  let root_ips = vCenter
  | where TimeGenerated between (ago(p_lookback) .. ago(t_lookback))
  | where EventType has_all ('UserLoginSessionEvent', 'root', 'logged in')
  | summarize make_set(SourceIP,128);
  vCenter
  | where TimeGenerated > ago(t_lookback)
  | where EventType   has_all ('UserLoginSessionEvent', 'root', 'logged in')
  | where SourceIP   !in (root_ips)  
id: 03e8a895-b5ba-49a0-aed3-f9a997d92fbe
triggerThreshold: 0
entityMappings:
- fieldMappings:
  - identifier: Address
    columnName: SourceIP
  entityType: IP
name: VMware vCenter - Root login

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "apiVersion": "2023-02-01-preview",
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/03e8a895-b5ba-49a0-aed3-f9a997d92fbe')]",
      "kind": "Scheduled",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/03e8a895-b5ba-49a0-aed3-f9a997d92fbe')]",
      "properties": {
        "alertRuleTemplateName": "03e8a895-b5ba-49a0-aed3-f9a997d92fbe",
        "customDetails": null,
        "description": "'Detects when root user login from uncommon IP address.'\n",
        "displayName": "VMware vCenter - Root login",
        "enabled": true,
        "entityMappings": [
          {
            "entityType": "IP",
            "fieldMappings": [
              {
                "columnName": "SourceIP",
                "identifier": "Address"
              }
            ]
          }
        ],
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMware vCenter/Analytic Rules/vCenterRootLogin.yaml",
        "query": "let p_lookback = 14d;\nlet t_lookback = 1h;\nlet root_ips = vCenter\n| where TimeGenerated between (ago(p_lookback) .. ago(t_lookback))\n| where EventType has_all ('UserLoginSessionEvent', 'root', 'logged in')\n| summarize make_set(SourceIP,128);\nvCenter\n| where TimeGenerated > ago(t_lookback)\n| where EventType   has_all ('UserLoginSessionEvent', 'root', 'logged in')\n| where SourceIP   !in (root_ips)\n",
        "queryFrequency": "PT1H",
        "queryPeriod": "P14D",
        "severity": "High",
        "status": "Available",
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "InitialAccess",
          "PrivilegeEscalation"
        ],
        "techniques": [
          "T1078"
        ],
        "templateVersion": "1.0.0",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0
      },
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
    }
  ]
}