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/