[code] select sum(a.time_unit), b.tn, b.title, c.login from time_accounting a, ticket b, system_user c where a.ticket_id=b.id and a.create_by=c.id group by a.ticket_id [/code]
I know its really simple, but im not an analyst! Thanks for input, Andy On 8/18/06 12:45 AM, "Alexander Scholler" <[EMAIL PROTECTED]> wrote: > Hi Andy, > > Andy Lubel schrieb: >> In Stats, OTRS has a great Time Accounting selection that details the > amount >> of time spent to handle each customer. This is good but we also need the >> accumulated time actually spent on any given ticket (i.e., by owner). >> >> I have tried to develop a SQL statement to do this using the > time_accounting >> table but the time units used in this table do not match what you see > if you >> pull up a ticket, zoom it and look under Accounted Time in the right hand >> column. > > > I think there is something wrong with your SQL-query. Post it here. > > Bye, Alex > _______________________________________________ > 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/