You can pretty easy create a query like: SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join system_user AS u ON t.create_by = u.id WHERE year(t.create_time) = '2006' GROUP BY t.create_by It will give you userid, firtstname, lastname, total work-units In 2006 Regards, Peter Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Donald Musser Verzonden: dinsdag 20 maart 2007 22:50 Aan: otrs@otrs.org Onderwerp: [otrs] Can I create stats for time units? Hello everyone, I've had a bit of exposure to OTRS, as my company has been using it as our ticketing system for months now. We recently made the decision to start recording work units, and I wanted to know if anyone knew of a way to incorporate work units into the STATS objects. More specifically, I wanted to get the work units (by minutes or hours) for a particular ticket queue within a given time period. Any suggestions? ~Myles