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:
<connect to mysql, e.g. mysql -u [user] -h [host] -p>
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
_______________________________________________
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 oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
