I think the database query is not that hard as there is a table "time_accounting" witch contains a time_unit and create_by field Use a good MySQL query tool (I use Navicat) and access the OTRS database or use the SQL box in the admin area. 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/