Re: [otrs] Closed Ticked Limit

14 Jul 2015

      Hello André,

If you want to find out whats the oldest ticket closed, run the following
query:

SELECT tn, create_time, MIN( id )
FROM ticket
WHERE ticket_state_id
IN (

SELECT id
FROM ticket_state
WHERE type_id =3
)

You could count them replacing the first line for:

SELECT COUNT( tn )

And you could list them all replacing the first line for:

SELECT tn, create_time

And appending the following line at the end:

ORDER BY `ticket`.`create_time` ASC

I hope it helps. Regards,

Leonardo Certuche