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/
