Zscaler - Connections by dormant user

Back


Id	66bc77ee-3e45-11ec-9bbc-0242ac130002
Rulename	Zscaler - Connections by dormant user
Description	Detects ZPA connections by dormant user.
Severity	High
Tactics	Persistence
Techniques	T1078
Required data connectors	CustomLogsAma
Kind	Scheduled
Query frequency	1h
Query period	14d
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsByDormantUser.yaml
Version	1.0.2
Arm template	66bc77ee-3e45-11ec-9bbc-0242ac130002.json

KQL

let dt_lastlogintime = 14d;
let activeUsers =
ZPAEvent 
| where TimeGenerated > ago(dt_lastlogintime)
| where DvcAction == 'open'
| summarize lastLoginTime = max(TimeGenerated) by DstUserName
| summarize makelist(DstUserName);
ZPAEvent
| where DstUserName !in~ (activeUsers)
| summarize EventCount = count() by DstUserName
| project-away EventCount
| extend AccountCustomEntity = DstUserName

YAML

queryFrequency: 1h
version: 1.0.2
queryPeriod: 14d
relevantTechniques:
- T1078
name: Zscaler - Connections by dormant user
kind: Scheduled
severity: High
tactics:
- Persistence
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsByDormantUser.yaml
requiredDataConnectors:
- datatypes:
  - ZPA_CL
  connectorId: CustomLogsAma
triggerOperator: gt
id: 66bc77ee-3e45-11ec-9bbc-0242ac130002
entityMappings:
- entityType: Account
  fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
triggerThreshold: 0
query: |
  let dt_lastlogintime = 14d;
  let activeUsers =
  ZPAEvent 
  | where TimeGenerated > ago(dt_lastlogintime)
  | where DvcAction == 'open'
  | summarize lastLoginTime = max(TimeGenerated) by DstUserName
  | summarize makelist(DstUserName);
  ZPAEvent
  | where DstUserName !in~ (activeUsers)
  | summarize EventCount = count() by DstUserName
  | project-away EventCount
  | extend AccountCustomEntity = DstUserName  
status: Available
description: |
    'Detects ZPA connections by dormant user.'

ARM