How I can delete all attachments from all closed Ticket?

[brwork]

Dear All,

I hope everyone is doing great Job.
I just wanted to check if I want to delete all attachments from all closed Ticket older than 30 days, how I can do? Any sql query or something I can schedule to carry out this task on weekly bases.

Thanks a lot.
BR Shrinet

[jojo]

there is a feature add on for this from OTRS.com

altertivly you can use Filesystem Storage for the attachments and create a shell script for deleting files

[brwork]

Hi jojo,

Thank you helping me again. Is this add on free or paid one ? And i am running OTRS on windows system so how i can run a shell script ? How i can store attachments on filestem and how i know what i need to delete ? Now proabably you will be thinking abt my all these questions But there is no such information in OTRS admin pdf abt this and all. i am relly sorry but a procedure for doing this correct will helps a lots of users here.

Thanks a lot for you prompt and kind supprt.

BR Shrinet

[EXG133]

Hi jojo,

Thank you helping me again. Is this add on free or paid one ?

You need a support contract for those addons. Depending on the contract you get 2, 5 or 10 addons included in the support contract price.

And i am running OTRS on windows system so how i can run a shell script ?

Scheduled task.

How i can store attachments on filestem and how i know what i need to delete ? Now proabably you will be thinking abt my all these questions But there is no such information in OTRS admin pdf abt this and all. i am relly sorry but a procedure for doing this correct will helps a lots of users here.

http://doc.otrs.org/3.1/en/html/performance-tuning.html