I would like to run a MySQL query that tells me how
many unanswered tickets I have in the entire OTRS database and the date of the
oldest one.
This is so I can insert it into a cgi page I use to
check the overall status of my website. Then I dont have to login to OTRS to see
if I need to clear it out.
I browsed through the tables today and couldnt
really figure it out.
Any help appreciated.
|
_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/