AW: AW: [otrs] Time Tracking more

29 Sep
2003
29 Sep
'03
8:51 a.m.
Hi Jerome, for agent specific accounting just summarize all entries with the same "Create by", and select the Days you want to see. SELECT create_by, sum( time_unit ) FROM time_accounting WHERE ( time_accounting.create_time > '01.09.2003' ) AND ( time_accounting.create_time < '30.09.2003' ) ORDER BY create_by GROUP BY create_by For Queue specifig accouting have to join the Ticket Table and group by the queue_id. Greetings Matthias
7963
Age (days ago)
7963
Last active (days ago)
0 comments
1 participants
participants (1)
-
Matthias Wegner