[code]
select sum(a.time_unit), b.tn, b.title, c.login
from time_accounting a, ticket b, system_user c
where a.ticket_id=b.id
and a.create_by=c.id
group by a.ticket_id
[/code]
I know its really simple, but im not an analyst!
Thanks for input,
Andy
On 8/18/06 12:45 AM, "Alexander Scholler"
Hi Andy,
Andy Lubel schrieb:
In Stats, OTRS has a great Time Accounting selection that details the amount of time spent to handle each customer. This is good but we also need the accumulated time actually spent on any given ticket (i.e., by owner).
I have tried to develop a SQL statement to do this using the time_accounting table but the time units used in this table do not match what you see if you pull up a ticket, zoom it and look under Accounted Time in the right hand column.
I think there is something wrong with your SQL-query. Post it here.
Bye, Alex _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/
--