Hi Edgar , I was searching for statistic related questions on the mailing list and came across your contribution , unfortunately the zip file was not present.
Could you possibly send me the zip file , I would really like to have a look at it. >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. Maybe it'll be of use to some of you ;-) . - 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 Best regards (and happy holidays), Edgar Meij Hostnet BV Singel 106 1015 AD Amsterdam The Netherlands helpdesk website: http://www.hostnet.nl/helpdesk helpdesk : E-mail Protected tel : 020 // 7500 811 fax : 020 // 7500 825 sales : E-mail Protected administratie : E-mail Protected > -----Original Message----- > From: Edgar Meij [mailto:[EMAIL PROTECTED] > Sent: 09 August 2005 04:49 PM > To: User questions and discussions about OTRS.org > Subject: Re: [otrs] OTRS statistics > > Hi Ravi, > > Can you try running a MySQL query and post the results: > > <connect to mysql, e.g. mysql -u [user] -h [host] -p> > > USE otrs > > SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE > history_type_id=1 AND create_time BETWEEN '2004-07-01' AND > '2004-07-31' + INTERVAL 1 DAY; > > Which version of OTRS are you using btw? You can also try and select > no queues. The script will then simply use all tickets. > > regards, > > Edgar Meij > > -- > 'An approximate answer to the right question is worth a great deal > more than a precise answer to the wrong question' > _______________________________________________ > 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/ _______________________________________________ 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/
