How to create a report on reassignment with the current and previous group columns?

[saint]

I want to create a report to show which tickets were reassigned from an assignment group , columns needed: Reassigned To and Reassigned by. Last 7 Days.

[DrewW]

By default the system will track the assignment group field value with a Metric.  But the system does not show in the metric_instance table the user who changed the value.  Getting the user that made the change is going to require a pull of data from the audit table and that is going to require some scripting and a custom table to hold the data.

The other option is to create a table for the data and then have a business rule insert new records when the assignment group field changes.  But this option is only moving forward unless you prepopulate it with a script that pulls data from sys_audit.

There are a number of other ways to generate the information but none of them are out of box.

[AndersBGS]

Hi @saint ,

Not really feasible as metric definition only hold 1 value - not 2. So you can see the assignment group that it came from and to but then not who assigned it. As alternative you could create 2 custom fields to hold explicit value - but again, that would also be a poor solution in general.