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@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/