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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Mayk Backus Inviato: mercoledì 11 febbraio 2009 17.16 A: otrs@otrs.org 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

If you use otrs manager you could see either what sql it use and you could take and change and use by hand ;) MV 2009/2/11 Mayk Backus :

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