
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2021 07:00 AM
How can I create a report showing user groups that contain no users? Also, groups with no roles assigned?
Thanks,
Adam
Solved! Go to Solution.
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2021 09:35 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2021 07:15 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2021 08:57 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2021 08:43 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2021 08:55 AM
Intersting, what happens if you change the filter with the name of that group, do you see it show in the table?