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

[sachin_namjoshi · Accepted solution]

You can create database view between sys_user_group and task table to find out assignment groups with no tickets assigned.

Database views

Regards,

Sachin

[tonybentivegna]

YES that works:

Data   [Table ]     Group [sys_user_group]

Type [List]

Group [   --None--]

[Adam Stout]

If you have Jakarta (or Istanbul with the Report Designer Enabled), you want to use a report with a Related List Condition.   No new view will be needed and you can get a clean list of records (one record per group not one record per incident).   You can also filter the incidents in the report (e.g., no P1 incidents, no incidents > 30 days old, no incidents from VIPs, etc.).

[Monica Burgess]

How would I use the Related List condition to show any assignment groups that currently have no task assigned to that group and another report to show groups that have had no tickets in 60 days?