Created by Claude - please verify

Headcount movement - member accounts by hire/creation date and leave date, deleted users in the recycle bin, leave dates in the next 30 days.

Required Microsoft Graph permissions

User.Read.All User-LifeCycleInfo.Read.All — application permissions, granted to the app registration with admin consent.

Licence: None.

Endpoints: GET /v1.0/users?$select=createdDateTime,employeeHireDate,employeeLeaveDateTime,department · GET /v1.0/directory/deletedItems/microsoft.graph.user (cached)

Deleted users stay in the recycle bin for 30 days only, so older leavers are counted from leave dates where HR maintains them.

If a permission is missing, this report shows a red load error with the Graph status code — not an empty table.

Joiners & Leavers Trend (12 months)

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.