Ping Federate - Unexpected country for user

Back


Id	64e65105-c4fc-4c28-a4e9-bb1a3ce7652d
Rulename	Ping Federate - Unexpected country for user
Description	Detects requests from different countries for user in shotr term.
Severity	Medium
Tactics	InitialAccess
Techniques	T1078
Required data connectors	CefAma
Kind	Scheduled
Query frequency	1h
Query period	1d
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederateUnexpectedUserCountry.yaml
Version	1.0.3
Arm template	64e65105-c4fc-4c28-a4e9-bb1a3ce7652d.json

KQL

let known_countries = 
PingFederateEvent
| where TimeGenerated between (ago(1d) .. (1h))
| where isnotempty(DstGeoCountry)
| summarize makeset(DstGeoCountry);
PingFederateEvent
| where isnotempty(DstGeoCountry)
| where DstGeoCountry !in (known_countries)
| extend AccountCustomEntity = DstUserName
| extend IpCustomEntity = SrcIpAddr

YAML

name: Ping Federate - Unexpected country for user
id: 64e65105-c4fc-4c28-a4e9-bb1a3ce7652d
description: |
    'Detects requests from different countries for user in shotr term.'
triggerThreshold: 0
entityMappings:
- fieldMappings:
  - columnName: AccountCustomEntity
    identifier: Name
  entityType: Account
- fieldMappings:
  - columnName: IpCustomEntity
    identifier: Address
  entityType: IP
version: 1.0.3
triggerOperator: gt
query: |
  let known_countries = 
  PingFederateEvent
  | where TimeGenerated between (ago(1d) .. (1h))
  | where isnotempty(DstGeoCountry)
  | summarize makeset(DstGeoCountry);
  PingFederateEvent
  | where isnotempty(DstGeoCountry)
  | where DstGeoCountry !in (known_countries)
  | extend AccountCustomEntity = DstUserName
  | extend IpCustomEntity = SrcIpAddr  
tactics:
- InitialAccess
kind: Scheduled
queryFrequency: 1h
severity: Medium
queryPeriod: 1d
requiredDataConnectors:
- dataTypes:
  - CommonSecurityLog
  connectorId: CefAma
status: Available
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederateUnexpectedUserCountry.yaml
relevantTechniques:
- T1078

ARM