Deleting old closed tickets

[TomC]

How do I delete old closed tickets to save space? Example: I want to delete all "closed" tickets that are over a month old, and purge their associated attachments. How can I do this?

Thanks in advance

[Jamie Edwards]

Hi Tom,

You could create a filter to search for all Closed tickets, and use the Mass Action menu bar to delete tickets in numbers at a time. Unfortunatly there is no search-and-purge.

I have moved your thread into the How To forum.

[TomC]

Hi Jamie,

Will deleting old tickets also delete/purge its associated attachments?

[craigbrass]

Yes.

[Jamie Edwards]

Originally Posted by TomC

Hi Jamie,

Will deleting old tickets also delete/purge its associated attachments?

Yes, it will. You can also choose to purge attachments only via the administrator control panel, under Maintainence.

[nolageek]

I can't seem to get more than 50 or so tickets listed. I set the default view to show 1000, 5000 and then 10000 tickets at a time... still, I have to delete 10000 spam tickets 40 at a time.

[tmancey]

Originally Posted by nolageek

I can't seem to get more than 50 or so tickets listed. I set the default view to show 1000, 5000 and then 10000 tickets at a time... still, I have to delete 10000 spam tickets 40 at a time.

Why is this not a feature with a cron job, as it makes sense. I cant believe this is not actually implemented when so useful.

Any response from Kayako would be great.

[craigbrass]

If you want such a feature to be included with Kayako, submit a feature request in the feature requests board here on the forum and it will be considered.

[Tim Meiers]

I had the same problem. I wanted to purge old tickets from 2005 to 2007. Rather than doing this by hand, 50 tickets at a time , I found a good solution that I want to share:
Use the free iMacros for Firefox web scripting add-on

I recorded a macro that searches for all closed tickets older than 12/29/2007 and then had iMacros check all 50 tickets, select delete and click ok.
Now I simply run the macro inside a loop and after my lunch break everything was deleted

Screenshot see attachment

My macro:

VERSION BUILD=6050612 RECORDER=FX
TAB T=1
TAB CLOSEALLOTHERS
URL GOTO=http://support.mybigcompany.com/staff/index.php?_m=tickets&_a=search
TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[1][0] CONTENT=$ticketstatusid
TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[1][2] CONTENT=3
TAG POS=1 TYPE=A ATTR=TXT: New<SP>Search<SP>Rule
TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[2][0] CONTENT=$lastactivity
TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[2][1] CONTENT=7
'Select date
TAG POS=1 TYPE=IMG ATTR=HREF:http://support.mybigcompany.com/themes/admin_default/calendar.gif
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:‹
TAG POS=1 TYPE=DIV ATTR=TXT:×
TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[2][1] CONTENT=$*less*
'TAG POS=1 TYPE=SELECT FORM=NAME:swiftform ATTR=NAME:searchrules[1][2] CONTENT=$*close*
'***********
WAIT SECONDS=2
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:index.php ATTR=NAME:submitbutton&&VALUE:Search
TAG POS=1 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=2 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=3 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=4 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=5 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=6 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=7 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=8 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=9 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=10 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=11 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=12 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=13 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=14 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=15 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=16 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=17 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=18 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=19 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=20 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=21 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=22 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=23 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=24 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=25 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=26 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=27 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=28 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=29 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=30 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=31 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=32 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=33 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=34 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=35 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=36 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=37 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=38 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=39 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=40 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=41 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=42 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=43 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=44 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=45 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=46 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=47 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=48 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=49 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=50 TYPE=INPUT:CHECKBOX FORM=NAME:ticketlist ATTR=NAME:itemid[] CONTENT=YES
TAG POS=1 TYPE=SELECT FORM=NAME:ticketlist ATTR=NAME:ma_options CONTENT=$delete
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:index.php ATTR=NAME:submitbtn&&VALUE:Go
WAIT SECONDS=5

[Jamie Edwards]

Hi Tim,

Welcome to the forums That's an interesting solution; one we haven't seen before! Thanks for sharing it.