[otrs] Tickets Average open time

Hi, I am trying to run metrics...to find out average time of tickets stay open, for say, a week, a month or total average from a given point in time. Any clues on how to achieve this, even if it means custom script fetching input from mysql db? Where is the best place to locate the mysql variable names? _Thanks Richard __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com