Deleting particular attachments

I figured this must be an FAQ by now, but apparently my users must be
dumber than the average bear, having gone over the wiki and the docs to no
avail. Having had a business-sensitive attachment sent in with a ticket,
I’m looking for the shortest-path to removing it from an RT 3.0.x (I know,
I know) instance. Any suggestions (i.e. sql DELETE statements) or pointers
to docs-for-the-impaired would be most, most welcome.

Adam

One word – to a wise man. http://web.baz.org/~adam/
One lash – to a bright horse. - Zen saying

There is not way to do this currently (that I would recommend) other
than deleting the ticket and then using Ruslan’s RTx::Shredder to
really get rid of it.

-ToddOn Tue, Feb 08, 2005 at 01:56:39PM -0500, Adam Hirsch wrote:

I figured this must be an FAQ by now, but apparently my users must be
dumber than the average bear, having gone over the wiki and the docs to no
avail. Having had a business-sensitive attachment sent in with a ticket,
I’m looking for the shortest-path to removing it from an RT 3.0.x (I know,
I know) instance. Any suggestions (i.e. sql DELETE statements) or pointers
to docs-for-the-impaired would be most, most welcome.

Adam


One word – to a wise man. http://web.baz.org/~adam/
One lash – to a bright horse. - Zen saying


The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

I figured this must be an FAQ by now, but apparently my users must be
dumber than the average bear, having gone over the wiki and the docs to no
avail. Having had a business-sensitive attachment sent in with a ticket,
I’m looking for the shortest-path to removing it from an RT 3.0.x (I know,
I know) instance. Any suggestions (i.e. sql DELETE statements) or pointers
to docs-for-the-impaired would be most, most welcome.

I haven’t updated this tool since I originally built it for a client who
was running RT 3.0, but my attachment deletion tool lives at:

http://download.bestpractical.com/pub/rt/contrib/3.0/Other/Censorware/