Hi Edgar, It gives me following o/p:- mysql> SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE history_type_id=1 AND create_time BETWEEN '2005-07-01' AND '2005-07-31' + INTERVAL 1 DAY; +----------------------------+ | COUNT(DISTINCT(ticket_id)) | +----------------------------+ | 2547 | +----------------------------+ 1 row in set (0.41 sec) We are using version otrs version 1.3.2. Regards Ravi Ahuja Edgar Meij wrote:
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