There is an earlier post from me, I've included it below. And there is
a readme file within the archive, have you tried those?
Regards,
Edgar
---
Dear all,
During the greater part of this year I've been developing a statistics
module for OTRS (and Hostnet). Attached you'll find a zip file with the
final result. See the README file within for further installation
details, requirements, etc. etc.
The script is able to produce the following ticket statistics,
aggregated on a per-day or per-week basis, between specified dates and
in specified queues. The output can be selected as well; graphs, CSV and
HTML (tables) are supported.
- Number of new tickets (total/calls/e-mails)
- Workload (number of calls, in- and outgoing e-mails)
efficiency:
- E-mail time calculations:
Open time
Reply time
Resolution time
efficacy:
- Average number of follow-ups/replies per ticket
- Number of first time fixes
An example graph is attached as workload.gif.
On 2/7/06, Simone Girlanda
may you give us more detailed installation instruction ?
thank you
-----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]Per conto di Edgar Meij Inviato: martedì 7 febbraio 2006 18.16 A: pas.de.quoi@voila.fr Cc: 'User questions and discussions about OTRS.' Oggetto: [otrs] OTRS statistics
Hi Rémi,
Sure, see the attached file. If you have any questions, drop me an e-mail.
Regards,
Edgar
-----Oorspronkelijk bericht----- Van: pas.de.quoi@voila.fr [mailto:pas.de.quoi@voila.fr] Verzonden: dinsdag 7 februari 2006 10:21 Aan: danie@verpakt.com; edgar.meij@gmail.com Onderwerp: OTRS statistics
Hi Edgar, Hi Danie
I use otrs too since june 2003 (1.3.2 at this time but I'm going to update to 2.0.4 soon) and I'm interested in statitics over OTRS database but I'm not an expert in SQL so, as Danie asked, could you possibly send me the zip file , I would really like to have a look at it (the ouputs that you have made meet my goals)
Thanks a lot
Rémi
_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
-- 'An approximate answer to the right question is worth a great deal more than a precise answer to the wrong question'
