"we have retention set up so I can't just right click and delete the archives... it will sit there at "pending" forever until I empty the archive and clear some bits in the SQL database. Yuck."
Can you clarify that bit for me because thats not how it should work, which means you have other issues going on
https://www.linkedin.com/in/alex-allen-turl-07370146