Help with Creating a Report

niharika verma
Tera Expert

I need to build a report with the following scenario:

 

a ticket assigned to Service desk was escalated to Client support group A (this time the incident is on hold and on hold reason is escalated to Client; for sctask the state is escalated to Client)

 

the same ticket was then reassigned to Client support group B

I want help in building report that will show that the ticket was initially assigned by Service desk to Client support group A

 

I am unable to generate this through incident metric or audit table. 

 

any ideas please?