Entra ID Users with past Employee Leave DateTime Attribute
The question it answers: Which accounts can still sign in although their employee leave date has passed?
At a glance
Section titled “At a glance”| Where in the app | Entra ID › Users › Expired / Left Users |
| Workload | Entra ID |
| Kind | Table |
| Data | Built from the tenant data IntensiveReports keeps in memory and refreshes in the background, so it opens at once. |
| Licence | No extra licence needed. |
| Report id (API and MCP) | entra.users.expired-left |
Columns
Section titled “Columns”| Column | Key | Type |
|---|---|---|
| Display Name | DisplayName | Text |
| User Principal Name | UserPrincipalName | Text |
| Employee Leave Date | EmployeeLeaveDateTime | DateTime |
| Account Enabled | AccountEnabled | YesNo |
Filters
Section titled “Filters”| Filter | Key (API) | On when the page opens |
|---|---|---|
| Hide disabled accounts | hide-disabled | Yes |
What it needs
Section titled “What it needs”Licence: No extra licence needed.
Application permissions on the IntensiveReports app registration (all permissions):
| Permission | API | What it allows | Note |
|---|---|---|---|
User.Read.All | Microsoft Graph | Read all users’ full profiles | |
User-LifeCycleInfo.Read.All | Microsoft Graph | Read all users’ lifecycle information |
Data sources it reads
GET /v1.0/users ($select=employeeLeaveDateTime,...)
Through the API and MCP
Section titled “Through the API and MCP”GET /ir-api/v1/reports/entra.users.expired-left?size=100GET /ir-api/v1/reports/entra.users.expired-left?filter=hide-disabledAn AI assistant reads it with the MCP tool get_report and the id entra.users.expired-left. The client needs the Read grant for Entra ID. See Using the API.