[otrs] Can I create stats for time units?

[Beugen, Peter van]

You can pretty easy create a query like:

 

SELECT

t.create_by,

u.first_name,

u.last_name,

Sum(t.time_unit)

FROM

time_accounting AS t

Left Join system_user AS u ON t.create_by = u.id WHERE

year(t.create_time) =  '2006'

GROUP BY

t.create_by

 

It will give you userid, firtstname, lastname, total work-units In 2006

 

Regards,

Peter

 

 

 

Van: otrs-bounces at otrs.org [mailto:otrs-bounces at otrs.org] Namens Donald
Musser
Verzonden: dinsdag 20 maart 2007 22:50
Aan: otrs at otrs.org
Onderwerp: [otrs] Can I create stats for time units?

 

Hello everyone,

I've had a bit of exposure to OTRS, as my company has been using it as
our ticketing system for months now. We recently made the decision to
start recording work units, and I wanted to know if anyone knew of a way
to incorporate work units into the STATS objects. More specifically, I
wanted to get the work units (by minutes or hours) for a particular
ticket queue within a given time period. Any suggestions? 

~Myles

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20070320/cc37a329/attachment.html