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 w
> 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,
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 tick
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
On Fri, Mar 26, 2010 at 01:10:10PM +0100, Christian Loos wrote:
> 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? [..] Bear in mind that if the ticket is closed and then
> > re-opened, the duration in wh
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
