Skip to content

Days Since Last Password Reset for Users

The question it answers: Which users last changed their password longer ago than the password age threshold?

Where in the appEntra ID › Users › Days Since Last Password Reset
WorkloadEntra ID
KindTable
DataBuilt from the tenant data IntensiveReports keeps in memory and refreshes in the background, so it opens at once.
LicenceNo extra licence needed.
Report id (API and MCP)entra.users.days-since-last-password-reset
ColumnKeyType
Display NameDisplayNameText
User Principal NameUserPrincipalNameText
Last Password Change DateLastPasswordChangeDateTimeDateTime

Licence: No extra licence needed.

Application permissions on the IntensiveReports app registration (all permissions):

PermissionAPIWhat it allowsNote
User.Read.AllMicrosoft GraphRead all users’ full profiles
User-LifeCycleInfo.Read.AllMicrosoft GraphRead all users’ lifecycle information
Data sources it reads
  • GET /v1.0/users ($select=lastPasswordChangeDateTime,...)
GET /ir-api/v1/reports/entra.users.days-since-last-password-reset?size=100

An AI assistant reads it with the MCP tool get_report and the id entra.users.days-since-last-password-reset. The client needs the Read grant for Entra ID. See Using the API.