Thank you for your answer, but if i want to select a queue or an agent , from a beginning date to an ending date ? Jerome Matthias Wegner wrote:

We summerize the time per customer, so you may take this as a start:

"SELECT customer_id, sum(time_unit) FROM time_accounting, ticket Where ticket.id=ticket_id group by customer_id"

Matthias Wegner

------------------------------------------------------------------------

_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/