How do you delete an attachment in ticket notes?

Question

I know how to delete an attachment that was attached to a ticket, there's a trash bin we can click right next to it. But the attachment I'm referring to is in the Notes section, like when someone sent a ticket update via email and attached an attachment to it, so now it's in the notes, but we need to delete the attachment now in the notes, is there a way to do it?

j_a_catlin · Accepted Answer

If you do not have the secure-delete option set for the tech that performed the delete of the ticket, you can undelete the ticket in the database.

If you are unsure it is setup, the steps to check for secure-delete setting can be found here:

Success Center

The steps for undeleting all tickets(these are specific to MS SQL Server, just do the similar steps for the DB you are using) in the DB are here:

Success Center

To modify the undelete all query to only undelete 1 specific ticket change the where clause so it is looking for job_ticket_id the the matching ticket number- here is an example that would work for ticket 37:

UPDATE JOB_TICKET

SET DELETED = 0

WHERE job_ticket_id = 37;