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

description: |
    'Detects ZPA connections by dormant user.'
kind: Scheduled
tactics:
- Persistence
requiredDataConnectors:
- connectorId: CustomLogsAma
  datatypes:
  - ZPA_CL
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsByDormantUser.yaml
severity: High
name: Zscaler - Connections by dormant user
triggerThreshold: 0
queryPeriod: 14d
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  
relevantTechniques:
- T1078
id: 66bc77ee-3e45-11ec-9bbc-0242ac130002
queryFrequency: 1h
status: Available
triggerOperator: gt
version: 1.0.2
entityMappings:
- entityType: Account
  fieldMappings:
  - columnName: AccountCustomEntity
    identifier: Name

ARM