Report for Reassignment

[Dawn Pierce]

How do I create a report for requests and Incidents that have been reassigned from one WG to another. EX: Assigned to Group A and Group A reassigned to Group B.

[Russell Abbott]

The reassignment count is saved on the incident_metric table. You can look at this by typing incident_metric.list into the nav.

Look at this table and use the filters to build the query you would like. You can base your report off of that

Word of caution, this table has a LOT of entries and queries can take a minute to run until you whittle down what you're looking for. Build your report first in Sub Prod.

Please mark as helpful or correct if this gets you what you need, don't hesitate to follow up to see if i can help you further

-Russ

[Dawn Pierce]

Thank you Russell.  If I put incident_metric.list in the filter navigator nothing is found.  If I go to reports Data > Table > Incident_Metric.  I don't see anything in that dropdown that has incident_metric.list.  I also tried setting up the conditions as:

Definition - is - Assignment Group

Value - is - XXXX

Reassignment - greater than - 0

Opened - on - This year

[Dawn Pierce]

Sorry, wrong attachment, here is the correct one.

[Dawn Pierce]

Sorry, wrong attachment, here is the correct one.