I use a cron driven bash script to run this query each night
to monitor the hours for which we're incurring obligations to
our contractors at YMD Partners LLC.
SELECT realname AS name,
round(sum(timetaken)/60.0,2) as hours,
q.name AS queue,
tix.id AS ticket,
tix.sta
On 6/12/10 1:49 PM, "RAT" wrote:
> We are nearly finished with a new RT deployment but the request was made to be
> able to print out reports for each user for each day showing hours worked and
> where there are gaps (I know *sigh*). I didn't see any reports or extensions
> that exactly fit the b
We are nearly finished with a new RT deployment but the request was made to be
able to print out reports for each user for each day showing hours worked and
where there are gaps (I know *sigh*). I didn't see any reports or extensions
that exactly fit the bill. Does anyone have any ideas?
Rob