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

id: 64e65105-c4fc-4c28-a4e9-bb1a3ce7652d
name: Ping Federate - Unexpected country for user
entityMappings:
- entityType: Account
  fieldMappings:
  - columnName: AccountCustomEntity
    identifier: Name
- entityType: IP
  fieldMappings:
  - columnName: IpCustomEntity
    identifier: Address
version: 1.0.3
queryFrequency: 1h
status: Available
kind: Scheduled
triggerThreshold: 0
relevantTechniques:
- T1078
triggerOperator: gt
queryPeriod: 1d
severity: Medium
tactics:
- InitialAccess
description: |
    'Detects requests from different countries for user in shotr term.'
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  
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederateUnexpectedUserCountry.yaml
requiredDataConnectors:
- connectorId: CefAma
  dataTypes:
  - CommonSecurityLog

ARM