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