I wrote a SQL query to do that.
This one queries the database for all closed
succesful tickets, calculating the time between creation and
closing.
SELECT tn, customer_id, create_time, freetime1 AS
real_close_time, DATEDIFF(freetime1, create_time) AS open_days,
TIMEDIFF(freetime1, create_time) AS open_time
FROM ticket
WHERE
ticket_state_id=2 AND '2007-01-01'<create_time AND
create_time<'2007-12-31' AND customer_id LIKE '%';
Now I'm writing something more complete in
PHP
Bye
Gabriele
----- Original Message -----
Sent: Monday, October 22, 2007 3:08
PM
Subject: [otrs] Stats reports ?
I would like to check the performance of the sevice team.
I tried to create reports, for exemple, based on difference
of ticket's creation time and ticket's close time.
This is not possible.
Have somebody any exsperience on this
issue?
Agim
_______________________________________________
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/