Re: [otrs] OTRS statistics

9 Aug 2005

      Hi Ravi,

Can you try running a MySQL query and post the results:

USE otrs

SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE
history_type_id=1 AND create_time BETWEEN '2004-07-01' AND
'2004-07-31' + INTERVAL 1 DAY;

Which version of OTRS are you using btw? You can also try and select
no queues. The script will then simply use all tickets.

regards,

Edgar Meij

-- 
'An approximate answer to the right question is worth a great deal
more than a precise answer to the wrong question'