Hi, I'm pretty sure you could do this with data from the ticket_history table. Select based on the ticket_id, and then based on the history_type_id (which in turns relies on the ticket_history_type table), you should be able to build up dates of when the ticket was received, replied to, and closed indefinitely/last.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Régis OBERLE Sent: 16 April 2008 13:09 To: otrs@otrs.org Subject: [otrs] SQL query for first response time and resolution time
Hello everybody,
I want to build a report showing first response time and resolution time. The stat module doesn't seem to be able to do this. So, I started using an external reporting tool. The hardest part is to build the SQL query. Can anybody help me finding these informations in the database ? Do I have to compute these informations from "start" and "end" fields, or is the data stored in the database (maybe the <ticket> table) ? Thank you for your help.
Regards,
Régis _______________________________________________ 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 or consulting for your OTRS system? =http://www.otrs.com/