A team "Service Desk" wants to be able to see how many incidents a particular user on their team has "reassigned" to another team. For example, a networking ticket comes in as an inbound email and defaults to the "Service Desk", then a member of the service desk (Person A) will assign the incident to the Network Operations Center. They would like to be able to more specifically see if an incident that they had assigned to a team got reassigned again. For example if the Network Operations Center routed the above incident to the DNS Infrastructure team I would like this incident to show up on Person A's report.
Restrictions:
I am not able to use history tables like sys_audit for performance reasons
I am not able to add a custom table to store this data
Thank you in advance!
-Nolen
