Report Query Required

Report Query Required

Can I please have the query for the following report :

Details of all complaints that have been Referred to a specific team by a technician. 
For Example; A technician who has been assigned a complaint , assigns it further to a team (Refer to Printer Team (that is also fed in the system as a technician) ) . I would like a report that shows details of such a complaint.

The following field are required:

Name of technician initially assigned to 
Name of team referred to 
Creation Date
Referred Date
Current Status


Also, I would like to know which table stores the information that is shown in the HISTORY tab of a request.




Thank You 

 



                  New to ADSelfService Plus?