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.
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