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 -- 'An approximate answer to the right question is worth a great deal more than a precise answer to the wrong question' _______________________________________________ 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/
