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

Robert Campbell
Tera Guru

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

 

RobertCampbell_0-1683066009842.png

 

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:

RobertCampbell_1-1683066115972.png

 

But it does not.

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@Robert Campbell 

this link has the solution

Report of groups with no users 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader