Hi Folks, Considering the 10.000 limit for closed tickets, I wonder how can I find a ticket older than 10.000. My system has now over 25.000 tickets in one year and 4 months. I tried seach, but it didn't find it. I user OTRS 4 running on Linux and MySql database. Thanks -- *André Luiz C. e Cavalcante, PMP, PRINCE2*
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
participants (2)
-
André Cavalcante -
Leonardo Certuche