Tickets closed by another tech
I have a situation where technicians are closing other techs tickets as part of a clean up activity. I need to produce a report that shows which technician closed tickets groups by day, who that ticket was assigned to, the date the ticket was created, and who created the ticket. We use SQL server.
Thank you.
Thank you.
| Created Date |
Request ID |
Technician |
Closed by |
Created by |
Closed Date |
| 9/1/15 |
12345 |
Sarah Lange |
Robert Jacobs |
Joe Swanson |
12/3/2015 |