Re: [otrs] clear old ticket from database
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: r...@kaldung.com - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] clear old ticket from database
it's possible to have the code? On 24 July 2012 15:41, Roy Kaldung 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 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.. > > - > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > > I suggest to use the API. There is a function for deleting tickets. > My delete date is older than 3 years, I do it with a perl script. > > Roy > > -- > Roy Kaldung > e-mail: r...@kaldung.com > - > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] clear old ticket from database
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 and check "Delete Tickets YES" in the Ticket Commands . I suggest testing this with a special queue consisting of junk and a short close time first before running it on production queues. -- stylebites Bernd Backhaus & Markus Hüsken GbR Im Wolfsfeld 17 44879 Bochum Tel. 0234 / 298 7664 http://www.stylebites.de : http://www.rewirpower-halbmarathon.de THE video player for the web: http://flowplayer.org - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] clear old ticket from database
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: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] clear old ticket from database
Or use Generic Agent. On Tue, Jul 24, 2012 at 9:41 AM, Roy Kaldung 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 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.. > > - > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > > I suggest to use the API. There is a function for deleting tickets. > My delete date is older than 3 years, I do it with a perl script. > > Roy > > -- > Roy Kaldung > e-mail: r...@kaldung.com > - > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] clear old ticket from database
Am Jul 24, 2012 um 3:29 PM schrieb 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.. > - > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs I suggest to use the API. There is a function for deleting tickets. My delete date is older than 3 years, I do it with a perl script. Roy -- Roy Kaldung e-mail: r...@kaldung.com - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
[otrs] clear old ticket from database
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.. - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
