I am interested in this too. Daniel
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Danie > Theron > Sent: Friday, January 27, 2006 10:09 AM > To: User questions and discussions about OTRS.org > Subject: RE: [otrs] OTRS statistics > > 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/ > > > -- > This message was scanned for spam and viruses by BitDefender. > For more information please visit http://www.bitdefender.com/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://www.bitdefender.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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
