Re: [otrs] Statistics on ticket history

[Marco Vannini]

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



-- 
Marco Vannini
home: +39 02 900091454
mobile: +39 335 5340819
msn: [EMAIL PROTECTED]
talk: [EMAIL PROTECTED]
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/