need to fetch removed users list from itil role

[Purushotham Ga2]

HI Experts,

How to create a report showing users with ITIL since 2025, as well as users who had ITIL roles removed.

Please assist me on this. 

[Huynh Loc]

Hi @Purushotham Ga2 ,

Users who have ITIL since 2025 (currently assigned)

Create a report on sys_user_has_roletable with:
Role = itil

Created on ≥ 01‑Jan‑2025

If this response was helpful, please consider marking it as Correct and Helpful. You may mark more than one reply as an accepted solution

[Tanushree Maiti]

Users Added to ITIL Since 2025
This report shows users who were assigned the 'itil' role from 2025 onwards.
Table: User Role (sys_user_has_role)
Conditions:
Role | Name | is | itil
Created | on or after | 2025-01-01 00:00:00

Users Who Had ITIL Role Removed
This report tracks removals, which is crucial for license reclamation.
Table: Deleted Records (sys_audit_delete)
Filters:
Table name | is | sys_user_has_role
Payload | Contains | itil
Deleted | on or after | 2025-01-01 00:00:00

Refer: https://www.servicenow.com/community/platform-analytics-forum/is-there-a-way-to-report-on-users-who-....