need to fetch removed users list from itil role
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
HI Experts,
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
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
