Report showing all assignment groups on On-Call

Senele
Tera Contributor

‎10-07-2024 01:38 AM

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

Labels:
0 Helpfuls
  • 465 Views
1 REPLY 1

Uncle Rob
Kilo Patron

‎10-07-2024 06:40 AM

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

 

#ServiceNow Reporting: Related Record Conditions
#ServiceNow Reporting: Related Record Conditions
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 &
0 Helpfuls