Re: [otrs] Statistics on ticket history

[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: [EMAIL PROTECTED] [EMAIL PROTECTED] 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/