Joiners & Leavers Trend (12 months)
The question it answers: How many people joined and left each month over the last year, by department, and who leaves in the next 30 days?
How many people joined and left each month, and in which departments - the headcount movement HR and finance ask IT for - plus everyone whose leave date falls in the next 30 days. New-starter Onboarding checks individual joiners; this report shows the trend.
At a glance
Section titled “At a glance”| Where in the app | Entra ID › Identity Governance & Lifecycle › Joiners & Leavers Trend |
| Workload | Entra ID |
| Kind | Findings list · dashboard tile |
| Data | Read from Microsoft 365 when someone first opens it, then kept for the report cache lifetime (Settings > Data & cache, 1 hour unless changed). |
| Licence | No extra licence needed. |
| Report id (API and MCP) | entra.governance.joiners-leavers |
Columns
Section titled “Columns”| Column | Key | Type |
|---|---|---|
| Severity | Severity | Status |
| View | Category | Text |
| Month / person / department | Subject | Link |
| Check | Setting | Text |
| Joined / left / deleted | Value | Text |
| Finding | Finding | Text |
| Departments | Detail | Text |
| Date | When | Date |
| Joiners | Number | Number |
A findings list hides columns that no row fills. Severity is Critical, Serious, Warning, OK or Info; rows rated Critical, Serious or Warning need attention (Working with findings).
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=createdDateTime,employeeHireDate,employeeLeaveDateTime,departmentGET /v1.0/directory/deletedItems/microsoft.graph.user (cached)
Through the API and MCP
Section titled “Through the API and MCP”GET /ir-api/v1/reports/entra.governance.joiners-leavers?size=100An AI assistant reads it with the MCP tool get_report and the id entra.governance.joiners-leavers. The client needs the Read grant for Entra ID. See Using the API.