Delete attachments of tickets older than xx months

Has someone done something like this before?

<?php
// Step 1:
query to find ticket_id of all tickets created xx months.

// delete all attachments of all threads under this ticket_id

Thanks