let forbidden_geo = dynamic(['CH']);
PingFederateEvent
| where isnotempty(DstGeoCountry)
| where tostring(DstGeoCountry) in~ (forbidden_geo)
| extend AccountCustomEntity = DstUserName
| extend IpCustomEntity = SrcIpAddr
status: Available
relevantTechniques:
- T1078
triggerThreshold: 0
severity: High
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederateForbiddenCountry.yaml
queryPeriod: 1h
query: |
let forbidden_geo = dynamic(['CH']);
PingFederateEvent
| where isnotempty(DstGeoCountry)
| where tostring(DstGeoCountry) in~ (forbidden_geo)
| extend AccountCustomEntity = DstUserName
| extend IpCustomEntity = SrcIpAddr
id: 14042f74-e50b-4c21-8a01-0faf4915ada4
entityMappings:
- fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
entityType: Account
- fieldMappings:
- columnName: IpCustomEntity
identifier: Address
entityType: IP
name: Ping Federate - Forbidden country
kind: Scheduled
description: |
'Detects requests from forbidden countries.'
tactics:
- InitialAccess
version: 1.0.3
triggerOperator: gt
queryFrequency: 1h
requiredDataConnectors:
- connectorId: CefAma
dataTypes:
- CommonSecurityLog