RE: Database pruning (was: RE: [otrs] Ticket history table full error)

9 Feb 2007

      Looks like about 9300 tickets...

mysql> select count(*) from otrs.ticket;
+----------+
| count(*) |
+----------+
|     9325 |
+----------+
1 row in set (0.00 sec)

-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Nils Breunese (Lemonbit)
Sent: Thursday, February 08, 2007 8:57 AM
To: User questions and discussions about OTRS.org
Subject: Re: Database pruning (was: RE: [otrs] Ticket history table full
error)

Jason B. Loven wrote:
...
Is there a quick way to tell?
You could for instance run an SQL query like this:

     SELECT COUNT(*) FROM otrs.ticket;

Nils Breunese.