Report on Time spent by each assignment group fro resolving an Incident

msm4
Mega Guru

Hello Team,

Can anyone help me , how to get a report on time spent by assignment groups to resolve an incident.

I tried using metric instance table, but I dont find exactly what I need.

Can anyone guide me in achieving this.

BR,

MSM.

6 REPLIES 6

Dubz
Mega Sage

You need to report on the incident_metric table, this is an OOB database view combining the incident table with the metric table. You can report on the OOB metric 'Assignment Group' which measures the field duration of the assignment group field on the incident form and will show you how long an incident was assigned to each group.

Thanks for the reply David, I tried with this table as well. But here I have a specific assignment group and now the list of incidents worked by the team long with who else worked on that incident.

I could not pull a report in specific to the group, I can get list of all incidents and which all groups worked on it.

 

Querying that table will yield a list of every metric definition set up on the incident table for every incident. You can use the filter conditions to show only the Assignment Group metric definition, from there you'll have a list of that metric for every incident. You can either group by incident to see all metric instances per incident or you can refine it further and search for a specific incident and you will only see the metric instances for that incident.

If you're looking for a report showing all metrics per group i would question the relevance of that report. Without the context of the duration of the incident the duration it was assigned to a group is kind of irrelevant.

Im not sure.. may be I failed to put my question in a proper way. Im looking for "Time spent by the different assignment groups on INC# which my team worked on" 

My Team worked on a INC# and reassigned to other group and they resolved it, need to knw time spent by each team.