
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/