This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
I don't know if it can be done in inside the application but I wonder if you could do it at the database level. I've not test this just an idea in case no one offers anything else, the query below would return all attachments form the incident form older than 30 days, you could write a delete statement using that criteria and schedule it to run every so often to clear attachments for that module. Not sure which modules you use but you may need to do the same for requests/tasks/changes/problems.
select im_creation_date, * from im_incident_attachment
where im_creation_date < getdate() - 30 -- (Current Day - 30 days)
order by im_incident_attachment.im_creation_date