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.ex e <http://www.mentattech.com/download/installer_mysql_turbo_manager_free.e xe> I like the Navicat tool. Regards, Peter Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/
_______________________________________________ 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/
