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
tactics:
- Persistence
relevantTechniques:
- T1078
version: 1.0.2
triggerOperator: gt
name: Zscaler - ZPA connections by new user
id: 236a7ec1-0120-40f2-a157-c1a72dde8bcb
description: |
'Detects ZPA connections by new user.'
queryFrequency: 1h
severity: Medium
status: Available
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
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Zscaler Private Access (ZPA)/Analytic Rules/ZscalerZPAConnectionsByNewUser.yaml
queryPeriod: 14d
triggerThreshold: 0
kind: Scheduled
entityMappings:
- fieldMappings:
- identifier: Name
columnName: AccountCustomEntity
entityType: Account
requiredDataConnectors:
- datatypes:
- ZPA_CL
connectorId: CustomLogsAma