How to get a report of groups with no users at all?

[Robert Campbell]

I am able to get a able to create a report that shows groups that have no users listed in them with:

However, this only identifies the groups that don't have members listed in the group. I want to get a list of groups that have no members listed and no groups listed.  I tried this with a db view but if you've been following me, you should know that db views and I aren't friends at all.

In my mind, this should work:

But it does not.

[bammar]

its kind of against intuition but you need to sort of flip the tables- make a report on the group table and then on the related list conditions then look the info up on the user table...

[AndersBGS]

Hi @Robert Campbell ,

Have you remembered the left join on the sys_user_group. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Robert Campbell]

A left join on the sys_user_group will display all the records of the table before it, correct?

[AndersBGS]

a left join on the sys_user_group will display all groups no matter if there is people assigned to that group or not. But maybe I misunderstood your question?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders