Hi. Try SQL: **** Mails per queue (via otrs. ticket) **** SELECT q.name, count (q.name) FROM otrs.article a, otrs.queue q, otrs.ticket t where article_type_id = 1 and a.ARTICLE_SENDER_TYPE_ID = 1 and a.create_time between to_date('05/06/2008 00:00:00', 'MM/DD/YYYY/HH24:MI:SS') and to_date('05/06/2008 23:59:59', 'MM/DD/YYYY HH24:MI:SS') and a.ticket_id = t.id and t.queue_id = q.id group by q.name order by q.name **** Mails per Agent (via ticket_history) **** SELECT su.login, count (th.id) from otrs.TICKET_HISTORY th, otrs.system_user su where history_type_id = 8 and th.create_time between to_date('05/06/2008 00:00:01', 'MM/DD/YYYY HH24:MI:SS') and to_date('05/06/2008 23:59:01', 'MM/DD/YYYY HH24:MI:SS') group by su.login order by su.login Greets, Daniel -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Richard Hinkamp - BeSite Sent: Mittwoch, 7. Mai 2008 13:00 To: User questions and discussions about OTRS.org Subject: [otrs] Statistics on ticket history Hello, I have a simple report to see how many tickets are closed per agent per period. What I really want is stats to see how many e-mails are sent per agent per period. The data I like to run the stats on is the ticket history. Here I want to check the amount of SendAnswer actions performed per agent. As far as I can see, the stats module is only for tickets. not the ticket history. Is there anything possible with stats on ticket history? Thanks in advance! Richard _______________________________________________ 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/