mysql query to get unanswered tickets and oldest ticket
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.
On Friday, January 09, 2004 9:43 AM
Seth Brundle
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.
Running queries directly against the database isn't recommended, but possible.
I browsed through the tables today and couldnt really figure it out.
Better browse through this lists' archives, you'll have much more luck there: http://lists.otrs.org/pipermail/otrs/ hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (2)
-
Robert Kehl -
Seth Brundle