I am using APN and email to generate tickets, and end up with tickets that are counted, but not shown anywhere in the interface. Previous topics referred to these as ghost tickets.
Thus
I am interested in some way to start fresh without having to do a full reinstall (clear non-essential databases)
Thoughts?
No idea what APN is (Access Point Name?) or why you think that you are getting "ghost tickets". But if for some reason you are getting tickets that are not associated with a department or team then you will continue to get them until you find and correct the issue that is creating it.
It's easier and faster to just wipe the whole database and start over.
You would want to delete the contents of the following tables:
*_attachment
*_draft
*_file
*_file_chunk
*_form_entry_values
*_note
*_organization__cdata
*_session
*_syslog
*_task
*_task__cdata
*_thread
*_thread_collaborator
*_thread_entry
*_thread_entry_email
*_thread_event
*_thread_referral
*_ticket
*_ticket__cdataadditionally if you want to remove all the users you would also to
*_user
*_user__cdata
*_user_account
*_user_email
Woops! I meant API (was working on my phones OS and slipped)..
Awesome. Thanks for that, Exactly what I was looking for.
Didn't consider that the tickets were just unassigned, and this not showing up.. will investigate this further.
Welcome to close this.
Thank you for the table names. However, you forgot to mention *_ost_form_entry which could cause a lot of strange errors if the table contains lots of data.