Deleted Tickets

In attempt to clean up data, a bulk delete was performed by an admin tech but did not have the "Secure Delete" feature checked. Technically it was only marked as deleted and still takes up storage on the database.

Is there a way to view all tickets that were marked as deleted through the web gui or the database?

Find more posts tagged with

web_help_desk_troubleshooting

webhelpdesk

web help desk administrator

web_help_desk_database

web_help_desk

whd

Accepted answers

All comments

pabely

Do a SQL query in the JOB_TICKET table and look for ones which have a "1" in the DELETED column

richard.valera

Thank you for your suggestion. I was able to do the query but there were many constraints set with foreign keys that prohibited me from deleting the tickets. I found that it was easier to do a query for all tickets with a "1" in the DELETED column and updating it to a "0". That way I could secure delete them from the WHD gui without having to worry about constraints.

Thanks again for your help!

pabely

Update Soft Delete flag on DB so they are visible again then correct secure delete Tickets as normal through UI.