1 Reply Latest reply on Apr 4, 2018 12:15 PM by icarriere

    Deleting old Web Help Desk content

    surfi2000

      Does anyone have a good MySQL query to permanently delete a job ticket from the DB? I'd basically want to do the same thing the 'Secure delete' button does (don't just mark the ticket as deleted in the DB but actually remove all data from the appropriate tables).

       

      I'd use the button or bulk actions but I have >300,000 tickets to delete so I have to do it at the DB level. I'm on WHD version 11.0.6