Why not just put some free text fields in the ticket and allow your
agents to log in, enter the start/end time for their activities, then
sum that up in a report? Or is what you're trying to do a bit more
complex than that?
-Original Message-
Message: 3
Date: Mon, 11 Aug 2008 14:21:33 -06
Ugh - sorry folks, I stink - I just found the sql box - that helps
dramatically! Thank you Tyler!
_
From: Tony Pagliaroli
Sent: Monday, August 11, 2008 10:32 AM
To: 'otrs@otrs.org'
Subject: Re: [otrs] Question about reports
On Wed, 27 Oct 2004 00:16:26 -0400, T
On Wed, 27 Oct 2004 00:16:26 -0400, Tyler wrote:
Here is an SQL statement that will poll this information. Change the
date/time to reflect the time period you want. If you don't want all
the
way to current date, then add
AND t.change_time <= '-MM-DD HH:MM:SS'
SELECT s.login, count( * )