Export of Pending time/Escalation time thru SQL box

Moderator: crythias

Locked
gecelann
Znuny expert
Posts: 164
Joined: 12 Feb 2016, 08:05
Znuny Version: 5.0.0
Real Name: ann
Company: rghdinc

Export of Pending time/Escalation time thru SQL box

Post by gecelann »

Hi everyone!

I would like to know if it still possible to generate the old pending time and date when we still use the generic agent?
What are the tables that are connected to the computation of pending time? and for escalation?

because i'm still having a hard time analyzing the columns in ticket, please see the screenshot below.
where did that values came from (timeout)? I noticed that the column for escalation or pending reminder[until_time] will go back to zero when it reset the time, is it possible to know what are the tickets that reached the pending reminder / escalation even if it reset the time?
Selection_110.png
You do not have the required permissions to view the files attached to this post.
Locked