[otrs] Counting responses used

Gabriele D'Andrea gabriele.dandrea at ecohmedia.com
Wed Nov 7 14:56:42 GMT 2007


You have got to query the database directly to do this.
First you got to understand the database structure
Take a look at
ftp://ftp2.otrs.org/pub/otrs/misc/otrs-2.0-database.png

As a quick suggestion, you could point attention to the article table: here you find the different notes, replies etc. that compose a ticket, in the same table, the a_to filed contains the addressee of your replies.

Hope this helps
Gabriele
  ----- Original Message ----- 
  From: Tabitha Stang 
  To: 'User questions and discussions about OTRS.org' 
  Sent: Wednesday, November 07, 2007 2:11 PM
  Subject: [otrs] Counting responses used


  Hi,

   

  My company would like to see how many incoming contacts we answer with each of our responses.

   

  I don't see this possibility under "Stats" or "Search".

   

  Does anyone have a solution or a good workaround for this?

   

  Thanks so much!

  Tabitha Stang

   



------------------------------------------------------------------------------


  _______________________________________________
  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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20071107/0ddc0ad6/attachment.html


More information about the otrs mailing list