[otrs] clear old ticket from database

2012-07-24 Thread Stefano Ricci
it's possible to clear old ticket from database? if is possible, the list of tables that i have to clear. for example, at the end of the year i create my macro statistics about the year and after a delete with a query the tickets from database... to start the new year with an empty history..

Re: [otrs] clear old ticket from database

2012-07-24 Thread Roy Kaldung
Am Jul 24, 2012 um 3:29 PM schrieb Stefano Ricci stefano.ri...@riccimatic.com: it's possible to clear old ticket from database? if is possible, the list of tables that i have to clear. for example, at the end of the year i create my macro statistics about the year and after a delete with

Re: [otrs] clear old ticket from database

2012-07-24 Thread Gerald Young
Or use Generic Agent. On Tue, Jul 24, 2012 at 9:41 AM, Roy Kaldung r...@kaldung.com wrote: Am Jul 24, 2012 um 3:29 PM schrieb Stefano Ricci stefano.ri...@riccimatic.com: it's possible to clear old ticket from database? if is possible, the list of tables that i have to clear. for

Re: [otrs] clear old ticket from database

2012-07-24 Thread Susan Dittmar
Quoting Gerald Young (cryth...@gmail.com): Or use Generic Agent. Do you per chance have an example of how to delete tickets using Generic Agent? Thanks in advance, Susan - OTRS mailing list: otrs - Webpage:

Re: [otrs] clear old ticket from database

2012-07-24 Thread Bernd Backhaus
Am 24.07.2012 16:31, schrieb Susan Dittmar: Do you per chance have an example of how to delete tickets using Generic Agent? just create a new job for the Generic Agent, select the relevant queues and the appropriate selection filter (we use ticket closed before) in the Ticket Filter options

Re: [otrs] clear old ticket from database

2012-07-24 Thread Stefano Ricci
it's possible to have the code? On 24 July 2012 15:41, Roy Kaldung r...@kaldung.com wrote: Am Jul 24, 2012 um 3:29 PM schrieb Stefano Ricci stefano.ri...@riccimatic.com: it's possible to clear old ticket from database? if is possible, the list of tables that i have to clear. for

Re: [otrs] clear old ticket from database

2012-07-24 Thread Roy Kaldung
On 7/24/12 5:13 PM, Stefano Ricci wrote: it's possible to have the code? Yes. See https://github.com/rkaldung/tc4o and download tc4o.DeleteOldTickets.pl into your /opt/otrs/bin folder. Adjust the TicketSearch and start first a dry run with debug mode. hth, Roy -- Roy Kaldung e-mail: