Request Status Report
Hi ,
Would you be able to assist with a MSSQL report:
Need to see the time taken to move between all request statuses per ticket.
Eg:
| Requestid |
Sla |
Priorty |
Created Date |
RequestStatus1 |
Time spent in status |
RequestStatus2 |
Time spent in status |
RequestStatus3 |
Time spent in status |
| 23088 |
Priority 1 |
3 Low |
2015/08/09 12:52 |
Open |
5Days : 45 min |
Pending Service Provider |
6Day : 63 min |
Pending Service Provider |
7Days : 12 min |
Thanks