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
There are a few caveats, but the SQL syntax and list of tables to modify in the Web Help Desk database are listed in the article below.
Hope this helps.
Web Help Desk Consultant
Adeptec: SolarWinds Training and Professional Services
○ LinkedIN: Adeptec
○ Facebook: Adeptec
○ Twitter: @Adeptec