Zscaler - ZPA connections outside operational hours

Back


Id	2859ad22-46c8-4cc7-ad7b-80ce0cba0af3
Rulename	Zscaler - ZPA connections outside operational hours
Description	Detects ZAP connections outside operational hours.
Severity	Medium
Tactics	InitialAccess
Techniques	T1190 T1133
Required data connectors	ZscalerPrivateAccess
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/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsOutsideOperationalHours.yaml
Version	1.0.0
Arm template	2859ad22-46c8-4cc7-ad7b-80ce0cba0af3.json

KQL

ZPAEvent 
| where DvcAction == 'open'
| where datetime_part("Hour", todatetime(LogTimestamp)) between (datetime_part("Hour", todatetime('19:01:00.7654321')) .. datetime_part("Hour", todatetime('08:01:00.7654321')))
| summarize count() by DstUserName 
| project DstUserName
| extend AccountCustomEntity = DstUserName

YAML

name: Zscaler - ZPA connections outside operational hours
query: |
  ZPAEvent 
  | where DvcAction == 'open'
  | where datetime_part("Hour", todatetime(LogTimestamp)) between (datetime_part("Hour", todatetime('19:01:00.7654321')) .. datetime_part("Hour", todatetime('08:01:00.7654321')))
  | summarize count() by DstUserName 
  | project DstUserName
  | extend AccountCustomEntity = DstUserName  
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsOutsideOperationalHours.yaml
queryFrequency: 1h
triggerThreshold: 0
requiredDataConnectors:
- dataTypes:
  - ZPAEvent
  connectorId: ZscalerPrivateAccess
version: 1.0.0
status: Available
queryPeriod: 1h
id: 2859ad22-46c8-4cc7-ad7b-80ce0cba0af3
triggerOperator: gt
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
  entityType: Account
relevantTechniques:
- T1190
- T1133
severity: Medium
description: |
    'Detects ZAP connections outside operational hours.'
kind: Scheduled
tactics:
- InitialAccess

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/2859ad22-46c8-4cc7-ad7b-80ce0cba0af3')]",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/2859ad22-46c8-4cc7-ad7b-80ce0cba0af3')]",
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules",
      "kind": "Scheduled",
      "apiVersion": "2022-11-01",
      "properties": {
        "displayName": "Zscaler - ZPA connections outside operational hours",
        "description": "'Detects ZAP connections outside operational hours.'\n",
        "severity": "Medium",
        "enabled": true,
        "query": "ZPAEvent \n| where DvcAction == 'open'\n| where datetime_part(\"Hour\", todatetime(LogTimestamp)) between (datetime_part(\"Hour\", todatetime('19:01:00.7654321')) .. datetime_part(\"Hour\", todatetime('08:01:00.7654321')))\n| summarize count() by DstUserName \n| project DstUserName\n| extend AccountCustomEntity = DstUserName\n",
        "queryFrequency": "PT1H",
        "queryPeriod": "PT1H",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0,
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "InitialAccess"
        ],
        "techniques": [
          "T1190",
          "T1133"
        ],
        "alertRuleTemplateName": "2859ad22-46c8-4cc7-ad7b-80ce0cba0af3",
        "customDetails": null,
        "entityMappings": [
          {
            "fieldMappings": [
              {
                "identifier": "Name",
                "columnName": "AccountCustomEntity"
              }
            ],
            "entityType": "Account"
          }
        ],
        "status": "Available",
        "templateVersion": "1.0.0",
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsOutsideOperationalHours.yaml"
      }
    }
  ]
}