[otrs] Accounted Time.

Hi, For accounting purposes, at the end of each month I would like to collect the following info using SQL Query: 1. Total time spent on each ticket for that month, output details: Ticket Number, Age, Accounted Time, Subject, State, Queue, Owner & CustomerID 2. Total time spent by each agent for that month, output details: Ticket Number, Age, Accounted Time, Subject, State, Queue, Owner & CustomerID How are the tickets linked up in the otrs database (relationships)? I have updated a ticket with Accounted time of 90 minutes. I can't find this info in the otrs database, where is it stored? Is there a way to collect the data and output it to a text file or .xls file? Thanks. Regards, Thau.