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.