PDA

View Full Version : Deleting old tickets and attachments


BrettLewis
08-30-2008, 01:55 PM
I've been closing and not deleting tickets, and now I'm sitting with a few hundred megs worth of attachments.

What is the easiest way for me to (find and) nuke the old closed tickets and the associated attachments?

Hildy
08-30-2008, 04:46 PM
If we're talking about Cerb4, then simply searching for the closed tickets and marking them deleted should be sufficient. The next time maintenance runs (generally at midnight), any tickets that are past the wait time will be purged from the db, and those deletes cascade (programmatically) to the other linked object types, which should include attachments.