Report of groups with no users

Adam H1
Tera Expert

How can I create a report showing user groups that contain no users? Also, groups with no roles assigned?

Thanks,

Adam

1 ACCEPTED SOLUTION

Eeson
Mega Guru

Hey Adam,

I find it easy to report on these types of use cases using the related list conditions.

For example

A list of your groups, then use the related list condition to return all groups with group members less than one.

Useful to also find groups over a particular value as well.

find_real_file.png

View solution in original post

9 REPLIES 9

Tsura Andreeva
Mega Sage

Check out the sys_user_grmember table, here is an idea for the filter

find_real_file.png

Thank you! That is exactly what I needed to know.  Seems there are tables for everything in SN, if you look hard enough. Apparently, I didn't look hard enough. 

Thanks for the help!

Adam

Hi Tsura,

Looking at this again, it isn't working as expected.  While looking at the list of user groups we found a couple OOTB groups that have no members but also are not showing up in the report I created based on your suggestions.  I think the reason is that groups that have 0 members don't get added to sys_user_grmember table.

Here is the report I am using, which has no results:

find_real_file.png

Yet, when I look at the sys_user_grmember table, I see at least one group with no users, as shown here:
find_real_file.png

 

Any suggestions?

Intersting, what happens if you change the filter with the name of that group, do you see it show in the table?