you'll need to look at ticket_history. But search for all the rows that havfe
that same ticket_id.
After that, you just need to find the create action and the close... and do the
math.
Duarte
--- Begin Message ---
Which tables stores the ticket age? I am interesting in the closing
time and how long the ticket stayed in the queue. I tried
time_accountiung and ticket_history.
mysql> select * from time_accounting where ticket_id=197;
+----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+
| id | ticket_id | article_id | time_unit | create_time |
create_by | change_time | change_by |
+----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+
| 64 | 197 | 472 | 1 | 2004-08-13 10:30:55 |
10 | 2004-08-13 10:30:55 | 10 |
+----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+
1 row in set (0.00 sec)
mysql> select id, ticket_id, create_time, change_time from
ticket_history where id=1815;
+------+-----------+---------------------+---------------------+
| id | ticket_id | create_time | change_time |
+------+-----------+---------------------+---------------------+
| 1815 | 197 | 2004-08-12 11:42:58 | 2004-08-12 11:42:58 |
+------+-----------+---------------------+---------------------+
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
--- End Message ---
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
