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 Jozsef Valkai Verzonden: woensdag 10 januari 2007 11:00 Aan: User questions and discussions about OTRS.org Onderwerp: Re: [otrs] Reporting Work Units

Hi all, this is probally a very newbie question for you, but how do i get the data on work units into a report? I dont see an option in stats for it, I am using OTRS 2.1.2. Is it something i would have to custom write a script for? I just want to be able to report on the amount of time each of my techs logs per week in OTRS. Any help would be greatly appreciated!!!

Yes, it will be a great function. I think it is very complicated database query. -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19° _______________________________________________ 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/