let listUsers =
ZPAEvent
| where TimeGenerated > ago(14d)
| where DvcAction == 'open'
| summarize ListofUsers = make_set(DstUserName) by DstUserName
| project ListofUsers;
ZPAEvent
| where DstUserName !in (listUsers)
| summarize EventCount = count() by DstUserName
| project-away EventCount
| extend AccountCustomEntity = DstUserName
id: 236a7ec1-0120-40f2-a157-c1a72dde8bcb
requiredDataConnectors:
- connectorId: CustomLogsAma
datatypes:
- ZPA_CL
entityMappings:
- fieldMappings:
- identifier: Name
columnName: AccountCustomEntity
entityType: Account
query: |
let listUsers =
ZPAEvent
| where TimeGenerated > ago(14d)
| where DvcAction == 'open'
| summarize ListofUsers = make_set(DstUserName) by DstUserName
| project ListofUsers;
ZPAEvent
| where DstUserName !in (listUsers)
| summarize EventCount = count() by DstUserName
| project-away EventCount
| extend AccountCustomEntity = DstUserName
triggerThreshold: 0
kind: Scheduled
severity: Medium
queryPeriod: 14d
tactics:
- Persistence
queryFrequency: 1h
status: Available
relevantTechniques:
- T1078
triggerOperator: gt
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsByNewUser.yaml
description: |
'Detects ZPA connections by new user.'
name: Zscaler - ZPA connections by new user
version: 1.0.2