There is an SQL box in the Admin area, but you probably better use a nice MySQL tool:

Recently I ran into a free -and pretty good- tool (so for anyone who it might interest):

http://www.mentattech.com/download/installer_mysql_turbo_manager_free.exe

I like the Navicat  tool.

Regards, Peter

Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Beugen, Peter van
Verzonden: dinsdag 20 maart 2007 23:07
Aan: User questions and discussions about OTRS.org
Onderwerp: RE: [otrs] Can I create stats for time units?

Yes:

month(t.create_time) = 3

see:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

and you can do anything on time/dates….

Regards, Peter

Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Donald Musser
Verzonden: dinsdag 20 maart 2007 23:03
Aan: User questions and discussions about OTRS.org
Onderwerp: Re: [otrs] Can I create stats for time units?

Hm...I see...simple enough, I suppose. Two questions come to mind in light of this info:

- would it be possible to reflect that so that it's easily viewable in the web interface?

- to modify the time period I'm searching for, could I do something like this tp get work units for March?
     month(t.create_time) = '03'

Thanks very much for your input.

~Myles

On 3/20/07, Beugen, Peter van < peter@tda.nl> wrote:

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@otrs.org [mailto:otrs-bounces@otrs.org] Namens Donald Musser
Verzonden: dinsdag 20 maart 2007 22:50
Aan: otrs@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

_______________________________________________
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
Support orr consulting for your OTRS system?
=> http://www.otrs.com/