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..
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: roy@kaldung.com
Or use Generic Agent.
On Tue, Jul 24, 2012 at 9:41 AM, Roy Kaldung
Am Jul 24, 2012 um 3:29 PM schrieb Stefano Ricci < stefano.ricci@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: roy@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
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
it's possible to have the code?
On 24 July 2012 15:41, Roy Kaldung
Am Jul 24, 2012 um 3:29 PM schrieb Stefano Ricci < stefano.ricci@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: roy@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
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: roy@kaldung.com
participants (5)
-
Bernd Backhaus -
Gerald Young -
Roy Kaldung -
Stefano Ricci -
Susan Dittmar