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

On Friday, January 09, 2004 9:43 AM Seth Brundle 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 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