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
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
_______________________________________________ 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/