Cleaning Attachments

RT Users
1

Hi,

Our RT3 system has Attachments table with size about 300GB. We’d like to
clean it by removing old records with files. The rt-shreder can do this job
properly I guess. But there is no way to specify query criteria there. Even
direct delete query is failed.

Does somebody can suggest how to clean Attachments table?

BTW, IMHO it’s bad idea to store files in the database cause it isn’t
scalable solution and it’s very difficult to upgrade/backup/restore DB.

Cheers,
Michael

2

Our RT3 system has Attachments table with size about 300GB. We’d like to clean it by removing
old records with files. The rt-shreder can do this job properly I guess. But there is no way
to specify query criteria there. Even direct delete query is failed.

rt-shredder allows query criteria.

-kevin

3

Our RT3 system has Attachments table with size about 300GB. We’d like
to clean it by removing
old records with files. The rt-shreder can do this job properly I
guess. But there is no way
to specify query criteria there. Even direct delete query is failed.

rt-shredder allows query criteria.

I tried rt-shreder from 3.8.2 and it accepts only files_only, file and
longer. No query.

-kevin

Does somebody can suggest how to clean Attachments table?

BTW, IMHO it’s bad idea to store files in the database cause it isn’t
scalable solution and
it’s very difficult to upgrade/backup/restore DB.

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Chicago, IL, USA — September 26 & 27, 2011
  • San Francisco, CA, USA — October 18 & 19, 2011
  • Washington DC, USA — October 31 & November 1, 2011
  • Melbourne VIC, Australia — November 28 & 29, 2011
  • Barcelona, Spain — November 28 & 29, 2011

Cheers,
Michael

4 
 > Our RT3 system has Attachments table with size about 300GB. We'd like to clean it by
 removing
 > old records with files. The rt-shreder can do this job properly I guess. But there is no
 way
 > to specify query criteria there. Even direct delete query is failed.

 rt-shredder allows query criteria.

I tried rt-shreder from 3.8.2 and it accepts only files_only, file and longer. No query.

Use perldoc rt-shredder to read the included documentation about
Plugins for ticket shredding.

-kevin