How do I create and assignment group report that shows all groups even those without tickets?

[tonybentivegna]

Friends,  

I need a report that will show me all the assignment groups in servicenow.

That report must include groups that have no tickets or requests or activity at all.

go!

Tony

[Kshitija1]

How would I use the Related List condition to show any assignment groups that currently have no task assigned to that group ??

[Adam Stout]

See the second example in this post.  It is looking for CIs (replace groups) with no outages (replace with tasks):  https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

[Kshitija1]

Thanks for your reply Adam.

I created a report on task table and trying to create related list condition on 'sys_user_group' table but unable to see this table. Could you please let me know which is that right table?

[Adam Stout]

Other way around.  You are looking for Groups (so your report needs to be on that table) with no Tasks.

The report is on sys_user_group and the related table is task.

[Kshitija1]

Thanks Adam,

I could generate the list. But is it possible to display these groups with 0 value along with other assignment groups that have assigned tickets in bar chart?