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