I'm also interrested in such an SQL statement. Regis -----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Marco Vannini Envoyé : mercredi 7 mai 2008 16:18 À : User questions and discussions about OTRS.org Objet : Re: [otrs] Statistics on ticket history Hi all, this is great... Is there someone that has a prepared sql statement to stat time of ticket ? I mean. time elapsed for a ticket, time spent in pending and/or related ? 10q. On Wed, May 7, 2008 at 3:43 PM, Obee, Daniel wrote:

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/ _______________________________________________ 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/

-- Marco Vannini home: +39 02 900091454 mobile: +39 335 5340819 msn: marco69v@hotmail.com talk: marco.vannini@gmail.com icq: 58389316 skype: marco69v _______________________________________________ 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/