[otrs] Summary of ticket states

[Gabriele D'Andrea]

I think the best solution is to query the database directly.
Take a look at ftp://ftp2.otrs.org/pub/otrs/misc/otrs-2.2-database.png (check the right version of your OTRS) for the database schema.

Gabriele
  ----- Original Message ----- 
  From: Clemens Zimmermann 
  To: otrs at otrs.org 
  Sent: Thursday, January 03, 2008 12:05 PM
  Subject: [otrs] Summary of ticket states


  Hi,

   

  I want to generate a daily summary on the states of all open tickets in the system, which are beyond a certain time (escalated) and send this via mail to certain people (e.g. the queue administrators).

   

  Has anyone a solution ?

   

  Thanks

  Clemens

   



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


  _______________________________________________
  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/20080103/86bf5217/attachment.html