Report of groups with no users

[Adam Head]

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

Thanks,

Adam

[Tsura Andreeva]

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

[Adam Head]

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

[Adam Head]

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:

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

Any suggestions?

[Tsura Andreeva]

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