Deleting tickets

RT Users
1

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.

2

Hello!

After deleting a several hundred of tickets (they were SPAM) a space
occupied by mysql database was not reduced.
I simply followed ‘Update all these tickets at once’ link, chose
’Deleted’ in ‘Make status’ combo box, and pressed Submit.

I suppose that the tickets in question was only marked as deleted, but
their content is still in DB. Is it true?

Is there any way to completely delete a number of tickets and to reclaim
space occupied by DB?

Thank you in advance.

3

Is there a way to delete tickets from RT? 3.6.0

Thanks

4

Is there a way to delete tickets from RT? 3.6.0

Thanks

Set the status of the ticket to be “deleted”?

Ben Norcutt
Network Manager
Wayland Community High School
Releasing the Spirit of Success

…

5

Is there a way to delete tickets from RT? 3.6.0

Thanks

Set the status of the ticket to be “deleted”?

DeleteTicket is an RT right that needs to be granted
to the users that need to delete tickets. If you want
the ticket to be really gone from the database you
need to use RTx::Shredder.

-Todd