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

[Jason B. Loven]

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 at otrs.org [mailto:otrs-bounces at 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.