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/