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