----- Original Message -----From: Gabriele D'AndreaSent: Tuesday, October 23, 2007 2:16 PMSubject: Re: [otrs] Stats reports ?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 PHPByeGabriele----- Original Message -----From: Agim CamiTo: otrs@otrs.orgSent: Monday, October 22, 2007 3:08 PMSubject: [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/
_______________________________________________
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/