hi
I want to a report showing first response time and resolution time
FirstResponseInMin, FirstResponseDiffInMin, FirstResponseTimeWorkingTime,
FirstResponseTimeEscalation, FirstResponseTimeNotification,
FirstResponseTimeDestinationTime, FirstResponse, TimeDestinationDate,
FirstResponseTime, UpdateTimeEscalation, UpdateTimeNotification,
UpdateTimeDestinationTime, UpdateTimeDestinationDate,
UpdateTimeWorkingTime, UpdateTime SolutionTime, SolutionInMin.
Can anybody help me finding these informations in the database ?
SQL query for FirstResponseInMin, FirstResponseDiffInMin
Moderator: crythias
-
kalyana1315
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact: