[rt-users] Deleting tickets

[Steve Poirier]

Hi all,

We installed rt 3 weeks ago, it was simple and in about 4 hours, i was
beginning training the techs on how to use it properly. Its a very good
system, very well done. Congratulations!

I found another way to run the server on a non-dedicated high traffic
machine without having all of the process that all handle rt, because rt
process are big. So we start another apache with a different config file on
port 10000 dedicated to rt.

We receive a lot of mail support. So the attachment table is becoming big
very fast. I tryed to figure out how attachments are linked to the Tickets
table so i can write a routine to permanently delete tickets (when they are
1 month old for example) and their transactions and attachments but doesnt
really understand. I figured out that when you open a ticket, it then open
it transactions by querying the Transaction table. You can find the
transactions for a ticket with the Ticket column (table: Transactions), but
in the transaction table i can't find how it's linked with the attachments
table. If someone wrote something like this or have any hints on what to
verify to correctly do it, let me know.

Regards,
__
Steve Poirier
Project manager
Inet-Technologies inc.