Ping Federate - Password reset request from unexpected source IP address..

Status: available
Severity: medium
Time window: 14d
Source: github.com/Azure/Azure-Sentinel

'Detects password reset requests from unexpected source IP address.'

MITRE ATT&CK coverage

Tactic	Techniques
Initial Access	`T1078` Valid Accounts

Rule body

id: 2d201d21-77b4-4d97-95f3-26b5c6bde09f
name: Ping Federate - Password reset request from unexpected source IP address..
description: |
  'Detects password reset requests from unexpected source IP address.'
severity: Medium
status: Available
requiredDataConnectors:
  - connectorId: CefAma
    dataTypes:
      - CommonSecurityLog
queryFrequency: 1h
queryPeriod: 14d
triggerOperator: gt
triggerThreshold: 0
tactics:
  - InitialAccess
relevantTechniques:
  - T1078
query: |
  let known_src = 
  PingFederateEvent
  | where TimeGenerated between (ago(14d) .. (1d))
  | where isnotempty(SrcIpAddr)
  | summarize makeset(SrcIpAddr);
  PingFederateEvent
  | where EventType =~ 'PWD_RESET_REQUEST'
  | where isnotempty(SrcIpAddr)
  | where SrcIpAddr !in (known_src)
  | extend AccountCustomEntity = DstUserName
  | extend IpCustomEntity = SrcIpAddr
entityMappings:
  - entityType: Account
    fieldMappings:
      - identifier: Name
        columnName: AccountCustomEntity
  - entityType: IP
    fieldMappings:
      - identifier: Address
        columnName: IpCustomEntity
version: 1.0.3
kind: Scheduled

Stages and Predicates

Let binding: `known_src` used in Stage 4

let known_src = PingFederateEvent
| where TimeGenerated between (ago(14d) .. (1d))
| where isnotempty(SrcIpAddr)
| summarize makeset(SrcIpAddr);

Stage 1: `source`

PingFederateEvent

Stage 2: `where`

| where EventType =~ 'PWD_RESET_REQUEST'

Stage 3: `where`

| where isnotempty(SrcIpAddr)

Stage 4: `where`

| where SrcIpAddr !in (known_src)

Stage 5: `extend`

| extend AccountCustomEntity = DstUserName

Stage 6: `extend`

| extend IpCustomEntity = SrcIpAddr

Exclusions

The rule actively suppresses these predicates.

Field	Kind	Excluded values	Search
`SrcIpAddr`	eq	`known_src`	`excludes:SrcIpAddr` `field:"SrcIpAddr" value:"known_src"`

Indicators

These rows show field, operator, and value matches.

Field	Kind	Values	Search
`EventType`	eq	`PWD_RESET_REQUEST`	`field:"EventType" kind:eq value:"PWD_RESET_REQUEST"`
`SrcIpAddr`	is_not_null	(no value, null check)	`field:"src_ip" kind:is_not_null`

Output fields

These fields are emitted when the rule matches.

Field	Source
`AccountCustomEntity`	`extend`
`IpCustomEntity`	`extend`

Ping Federate - Password reset request from unexpected source IP address..

MITRE ATT&CK coverage

Rule body

Stages and Predicates

Let binding: known_src used in Stage 4

Stage 1: source

Stage 2: where

Stage 3: where

Stage 4: where

Stage 5: extend

Stage 6: extend