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.