Ping Federate - Forbidden country

Back


Id	14042f74-e50b-4c21-8a01-0faf4915ada4
Rulename	Ping Federate - Forbidden country
Description	Detects requests from forbidden countries.
Severity	High
Tactics	InitialAccess
Techniques	T1078
Required data connectors	CefAma
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederateForbiddenCountry.yaml
Version	1.0.3
Arm template	14042f74-e50b-4c21-8a01-0faf4915ada4.json

KQL

let forbidden_geo = dynamic(['CH']);
PingFederateEvent
| where isnotempty(DstGeoCountry)
| where tostring(DstGeoCountry) in~ (forbidden_geo)
| extend AccountCustomEntity = DstUserName
| extend IpCustomEntity = SrcIpAddr

YAML

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

ARM