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
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/PingFederate/Analytic Rules/PingFederatePasswordRstReqUnexpectedSource.yaml
queryFrequency: 1h
name: Ping Federate - Password reset request from unexpected source IP address..
severity: Medium
triggerThreshold: 0
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
requiredDataConnectors:
- dataTypes:
- CommonSecurityLog
connectorId: CefAma
relevantTechniques:
- T1078
status: Available
triggerOperator: gt
queryPeriod: 14d
description: |
'Detects password reset requests from unexpected source IP address.'
id: 2d201d21-77b4-4d97-95f3-26b5c6bde09f
version: 1.0.3
entityMappings:
- fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
entityType: Account
- fieldMappings:
- columnName: IpCustomEntity
identifier: Address
entityType: IP
kind: Scheduled
tactics:
- InitialAccess