Re: [otrs] mysql query to get unanswered tickets and oldest ticket

2004-01-09 Thread Robert Kehl
On Friday, January 09, 2004 9:43 AM Seth Brundle <[EMAIL PROTECTED]> wrote: > 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 poss

[otrs] mysql query to get unanswered tickets and oldest ticket

2004-01-09 Thread 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.   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 c