I think this will do: 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 Custom the query yourself or mail me if you need any more help regards, Peter -----Oorspronkelijk bericht----- Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Atanas Karashenski Verzonden: maandag 22 januari 2007 15:43 Aan: otrs@otrs.org Onderwerp: [otrs] Time Accounting report Hello, I use OTRS 2.1.4 on SuSE 10.2 and I want to create a report which calculates work units spent by agents working on tickets with particular customerID during given month. Is it possible to create such report using report creation wizard or I have to do additional coding? In case I have to do some coding what is the way to integrate it with OTRS - I checked developer documentation, but it seems that there are some differences between 2.0 and 2.1 versions (Only 2.0 is available on the web site). Thank you very much Atanas Karashenski _______________________________________________ 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/