how can i report on how long a ticket has been with the opening group before being assigned to another group

emmab1
Kilo Contributor

how can i report on how long a ticket has been with the opening group before being assigned to another group

can I use standard servicenow reporting or do I need an addon?

12 REPLIES 12

maalto
Kilo Contributor

This would be the assignment group metric which shows how long the ticket has been assigned to a assignment group.



I'm just wondering how you would be able to find which group was the "opening group"?


Did you find an answer to this?? i'm trying to find duration from opening the ticket to first group assignment as well.

You should be able to find out who the first assignment group on the record was by querying the 'Record History' table sys_history_set

Adam Stout
ServiceNow Employee
ServiceNow Employee

Take a look at the SLA Breakdown Definitions in London (https://docs.servicenow.com/bundle/london-release-notes/page/release-notes/it-service-management/ser...).  This may give you what you want with minimal configuration.

SLA isn't tied to every incident so we can't report on this.