I use this MySQL query (OTRS 2.3.4, swap users with system_user if you use 2.2.x) to calculate accounted time e.g on a specified year. It would be great to put it on a static stat, but I'm not able to do that...
SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join users AS u ON t.create_by = u.id WHERE year(t.create_time) = '2008' GROUP BY t.create_by Hope this helps, d. ________________________________ Da: [email protected] [mailto:[email protected]] Per conto di Mayk Backus Inviato: mercoledì 11 febbraio 2009 17.16 A: [email protected] Oggetto: [otrs] Time reporting Hi All, Does anyone know of something on how to produce a time report of for example today, or a specific day ? The reason for this is that our company sends bills for given services. In the ticket we note the time we spend on a ticket, and it would be great of i could produce some sort of output on what tickets have received time units that day , by whom , how many time units , etc . I'm looking at OTRS Manager, it has something like this in the reports it generates, but i notice sometimes it doesn't display a ticket what i know of that has received time that day. So i doubt the reliability of it. Any news welcome. Perhaps someone has a php script that does these outputs, of has created a stats report or maybe something complete different. Hope to hear from you. kind regards, Mayk
_______________________________________________ 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
