Inventory self-service password resets
Finding
The first search establishes who normally uses SSPR and highlights rare or sensitive-user resets.
SSPR is a normal control, so the hunt starts with identity/population context rather than treating every reset as malicious.
View query
Q-01First searchInventory self-service password resets
What this checks
Build a baseline of successful SSPR usage by user, time, and surrounding recovery activity.
KQL
AuditLogs
| where TimeGenerated >= ago(30d)
| where LoggedByService =~ "Self-service Password Management"
| where OperationName =~ "Reset password (self-service)"
| where Result =~ "success"
| extend
TargetUser = tolower(tostring(TargetResources[0].userPrincipalName)),
TargetUserId = tostring(TargetResources[0].id)
| summarize
FirstReset=min(TimeGenerated),
LastReset=max(TimeGenerated),
ResetCount=count(),
Correlations=make_set(CorrelationId, 50)
by TargetUser, TargetUserId
| order by ResetCount asc, LastReset descSPL
index=<entra_audit_index> sourcetype=<entra_audit_sourcetype>
earliest=-30d
OperationName="Reset password (self-service)"
| eval
user=lower(coalesce(user, TargetUserPrincipalName, userPrincipalName)),
result=lower(coalesce(result, Result)),
correlation_id=coalesce(correlation_id, CorrelationId)
| where result="success"
| stats
min(_time) as first_reset
max(_time) as last_reset
count as reset_count
values(correlation_id) as correlations
by user
| convert ctime(first_reset) ctime(last_reset)
| sort reset_count - last_resetWhat to look for
Users with rare, clustered, or role-sensitive password-reset activity suitable for deeper review.
Technical details
Tested signal
Successful self-service password resets across the tenant.
Assumptions
- Entra SSPR audit events are exported for the hunt window.
Data requirements and relevant fields
- identity
Microsoft Entra audit events for self-service password reset and authentication-method changes.
TimeGeneratedLoggedByServiceCategoryOperationNameResultResultReasonInitiatedByTargetResourcesAdditionalDetailsCorrelationId
KQL schema
Validate connector availability, nested-field shape, retention, and licensing before operational use.
SPL schema
Replace index/sourcetype placeholders and map the documented identity, Graph, and Azure control-plane concepts to local fields.
Limitations
- SSPR is expected in many environments and baseline frequency varies by population.
KQL uses Microsoft Entra / Azure Monitor telemetry. SPL is a normalized raw-event scaffold and requires local field mapping.