Automatically purging old, closed requests

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

                New to ADSelfService Plus?