I'd like to generate a report that specifically identifies users with exactly 2 subscriptions. I've applied a filter based on user roles and grouped the data by users. While it correctly identifies users with 2 licenses, it also shows users with just 1 license. How can I refine the report to isolate users with only 2 subscriptions?
Hi @Sam M
to achieve your requirement you need another approach - in that case a classic report, as you can not only define related list conditions but also enter the exact number of matches.
- Make sure that in system property glide.ui.permitted_tables the table sys_user_role is listed
- Create a list report on table sys_user_role (add any conditions if you want to reduce the roles to a certain set)
- Define a related list condition on "Users" (this is not a related list but a relationship) with "Equals to 2"
The result is a list of roles which have assigned exact 2 users each.
Maik
