Automatically purging old, closed requests
We have been using SupportCenter for many years and have hundreds of thousands of old, closed requests. We have an archive policy to move them to archive after six months, but really have no need to retain closed tickets after a year. The number and size of the requests makes backup and recovery take an extremely long time, even trimmed backups.
Is there a script or SQL command we can use to purge closed requests after a set amount of time?
Thanks,
Ryan
Ryan