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 <[EMAIL PROTECTED]> wrote: > may you give us more detailed installation instruction ? > > thank you > > -----Messaggio originale----- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di > Edgar Meij > Inviato: martedì 7 febbraio 2006 18.16 > A: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Verzonden: dinsdag 7 februari 2006 10:21 > > Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > 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'
workload.gif
Description: GIF image
_______________________________________________ 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/
