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: [email protected] 
  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/
_______________________________________________
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/

Reply via email to