Deleting all the tickets from admin login

vineethshyam · **Deleting all the tickets from admin login -** 27-09-2006, 05:59 AM

Hey folks,
How do I delete all the tickets from admin login
I just did a stupid email parsing configuration and it created some 200 tickets of the same content with different ticket ids. I want to delete at a time.Please help me immediately
I have a admin login to my kayako.

sureshkumar.mr · 27-09-2006, 06:04 AM

In the header, before Ticket ID there is a check box, click on that. It will select all the tickets.

Go to the end, in the Options drop down list select Delete, scroll to the right side, you can see Go button. Click on that. This action should delete all the tickets.

This action you need to do using Staff login.

vineethshyam · 27-09-2006, 06:11 AM

Thanks.But that is paginated.And some 200 tickets are created .So I want to delete all of them

supportskins · 27-09-2006, 08:55 AM

Is the email using which the tickets were created the same? If yes then you can run a MySQL query on your database to delete all the tickets at once.

Neil-UKWSD · 27-09-2006, 09:40 AM

Hi,

You could alter the display settings to list all the tickets on one page, from the ticket listing page click on the pop out menu near the pagnation at the top of the list: Views > View Options > Edit View

Edit the number of tickets to show per page from the default 20 to a number large enough to list all your tickets on one page and save.

Now from the ticket list you should see all tickets, simply click the check box in the top row to select all then use the mass delete option to remove them.

escMark · 27-09-2006, 08:58 PM

I have a related question about this. I like to periodically copy our live system over to a development version so that we can test new versions or workflows, or code changes.

However, I usually don't want the production *data*, just the settings. I have SQL access, and I realize I could just do a delete from swtickets, but I was wondering if there was a complete list of tables I should clear out that relate to swtickets? Or is there a supportsuite function to clean up tables' referential integrity?

eiden · 27-09-2006, 10:00 PM

swauditlogs
swattachments
swattachmentchunks
swticket* (except swticketstatus, swviewfields and swticketviews)

It could be a good idea to wipe the userdata as well from:
swusers
swuseremails

I'm not sure about the structure on the swcustom* tables ..

Did I miss any ?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Admin not seeing assigned tickets	marcusg70	SupportSuite, eSupport and LiveResponse	7	23-05-2006 04:25 PM

vineethshyam Offline Member Posts: 68 Join Date: Sep 2006	Deleting all the tickets from admin login - 27-09-2006, 05:59 AM Hey folks, How do I delete all the tickets from admin login I just did a stupid email parsing configuration and it created some 200 tickets of the same content with different ticket ids. I want to delete at a time.Please help me immediately I have a admin login to my kayako.

sureshkumar.mr Offline Member Posts: 149 Join Date: May 2006	27-09-2006, 06:04 AM In the header, before Ticket ID there is a check box, click on that. It will select all the tickets. Go to the end, in the Options drop down list select Delete, scroll to the right side, you can see Go button. Click on that. This action should delete all the tickets. This action you need to do using Staff login.

vineethshyam Offline Member Posts: 68 Join Date: Sep 2006	27-09-2006, 06:11 AM Thanks.But that is paginated.And some 200 tickets are created .So I want to delete all of them

supportskins Offline Senior Member Posts: 3,681 Join Date: Aug 2006 Location: Mumbai, India	27-09-2006, 08:55 AM Is the email using which the tickets were created the same? If yes then you can run a MySQL query on your database to delete all the tickets at once. Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ SupportSkins.com - http://www.supportskins.com/

eiden Offline Member Posts: 237 Join Date: Apr 2006 Location: Norway	27-09-2006, 10:00 PM swauditlogs swattachments swattachmentchunks swticket* (except swticketstatus, swviewfields and swticketviews) It could be a good idea to wipe the userdata as well from: swusers swuseremails I'm not sure about the structure on the swcustom* tables .. Did I miss any ?