Hello people!
I am trying to create a SQL query to show the date and time the ticket was created and the date and time of the first attendance of that ticket. Also, let the "delay" of the first response be shown.
I already tried some suggestions from the forum, like this: viewtopic.php?t=26622, but did not answer me.
Any suggestion ? Thank you!
First Response Time Statistics for SLA report
Moderator: crythias
-
nedmaj
- Znuny expert
- Posts: 167
- Joined: 26 Nov 2014, 20:34
- Znuny Version: 6.3.4
- Real Name: Samuel Casimiro
- Company: Câmara dos Deputados
- Contact:
Re: First Response Time Statistics for SLA report
What you mean by "first attendance"??
Samuel
Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000