Report showing all assignment groups on On-Call

Senele
Tera Contributor

Good People,

I need a report that will list all assignment groups that are being used on the On-Schedule. So I need to know for example out of my 250 assignment groups how many have an On-schedule defined.

Just a note I am on ITSM standard, washington release

 

Thank you kindly

 

Senele

1 REPLY 1

Uncle Rob
Kilo Patron

Best bet is with a report with a related list condition.  Build the report on the group table, then whichever table is storying those on-schedule records... there should be a reference back to the group.  Find that reference in the Related List Conditions and make sure that you're returning where the count is greater than 0.  Not sure if these are the precise conditions, but you should get the idea...

UncleRob_0-1728308394519.png

 

Here's a video that explains the concept
https://youtu.be/gkzKzSXbwk0

 

In under 5 minutes learn how to report in #ServiceNow when the conditions have to do with records *related* to what you're reporting on? For example, how many Incidents have NO Incident_tasks? ▼▼▼ Expand for loads of helpful links ▼▼▼ Get on my mailing list! http://bit.ly/fedoruk Need passionate &