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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Donald Musser Verzonden: dinsdag 20 maart 2007 22:50 Aan: [email protected] 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
_______________________________________________ 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/
