On Wed, Mar 24, 2010 at 02:43:36PM +0100, Jesper Henriksen wrote:
Is there a way to get reports on how much time a ticket has been open?
For example we would like to see the average time it takes from when a
customer reports a problem till we have closed the ticket. Bear in mind
that if the
On Wed, Mar 24, 2010 at 09:58:37AM -0700, Allen wrote:
Is there a way to get reports on how much time a ticket has been open?
I know this is not the sanctioned way to do things because it is not
using RT APIs, but it works for now:
[..lots of SQL..]
Thanks. But we were hoping that RT
Am 24.03.2010 14:43, schrieb Jesper Henriksen:
Hey all,
Is there a way to get reports on how much time a ticket has been open?
For example we would like to see the average time it takes from when a
customer reports a problem till we have closed the ticket. Bear in mind
that if the ticket is
Hey all,
Is there a way to get reports on how much time a ticket has been open?
For example we would like to see the average time it takes from when a
customer reports a problem till we have closed the ticket. Bear in mind
that if the ticket is closed and then re-opened, the duration in which
it
Is there a way to get reports on how much time a ticket has been open?
I know this is not the sanctioned way to do things because it is not
using RT APIs, but it works for now:
# How many days have tickets been open:
SELECT id, EffectiveId, Created, Resolved, WEEK(Created) as week, Status,