- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 01:22 AM
Within my org we want to report on the department data held within ServiceNow and I want to create a report which shows departments which are empty OR have ONLY inactive users in them (not active and inactive).
Can anyone assist with how this report would be configured?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 01:56 AM
Create your report like below. The related list conditions will check (in this case) if there are no active users with a certain department. For testing I inactivated all users on department 'development' and moved all users from 'hr' to 'it', causing them to show up, because I am searching for 'Less than or Equal to 0'.
Related list conditions are awesome!!
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 01:56 AM
Create your report like below. The related list conditions will check (in this case) if there are no active users with a certain department. For testing I inactivated all users on department 'development' and moved all users from 'hr' to 'it', causing them to show up, because I am searching for 'Less than or Equal to 0'.
Related list conditions are awesome!!
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark