Best way to report on departments with no users or ONLY Inactive users

[Jamesk]

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

[Mark Manders · Accepted solution]

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!!