Andrew.
I removed 45k ticket with Generic Agent.
You can create a Generic Agent for this tickets and run on Command Line on
linux ;-)
su - otrs -c '/opt/otrs/bin/otrs.GenericAgent.pl'
Best Regards.
--! *Dilson Tomé Rainov wrote: Not working… I guess it might take some time to close 25K tickets.**** ** ** Andrew Meyer**** *Precision Practice Management***** T:314-787-0681 D: 314-881-5265 C: 314-565-0868 F: 314-881-5365**** Email: ameyer@precisionpractice.com**** ** ** *From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf
Of *Muhammad El-Sergani
*Sent:* Tuesday, September 25, 2012 10:36 AM
*To:* User questions and discussions about OTRS.
*Subject:* Re: [otrs] Mysql Help**** ** ** I vote for Generic Agent as well.
Works very good.
**** ** ** Thanks**** //M**** **** On Tue, Sep 25, 2012 at 4:57 PM, Alvaro Cordero Hello Andrew, I believe it is better to do it through the Generic Agent Interface, since
there are more than one database table involved into ticket information.
You could run a delete from ticket command, but it will still keep data
into ticket history, article and other tables. Best Regards. **** On Tue, Sep 25, 2012 at 8:52 AM, Andrew Meyer <
AMeyer@precisionpractice.com> wrote:**** I need to close about 25,000 tickets all with the same email address.
I was hoping to do this within the MySQL Workbench or at the command line.
**** Can anyone assist me in executing this command?**** **** Thanks,**** **** Andrew Meyer
Unix Systems Administrator
*Precision Practice Management*
*The business behind the practice.***** **** [image: Description:
http://www.precisionpractice.com/EmailSignature/images/logoTeamLeader.jpg]
**** D: 314-881-5265**** [image: Description:
http://www.precisionpractice.com/EmailSignature/images/spacer.gif]**** C: 314-565-0868**** [image: Description:
http://www.precisionpractice.com/EmailSignature/images/spacer.gif]**** F: 314-881-5365**** [image: Description:
http://www.precisionpractice.com/EmailSignature/images/spacer.gif]**** **** 689 Craig Road, Creve Coeur, MO 63141
Main Phone: 314-787-0681
www.PrecisionPractice.com
Email: ameyer@precisionpractice.com**** CONFIDENTIALITY NOTICE: This e-mail, including attachments, may include
protected health information (PHI), confidential and/or proprietary
information, and may be used only by the person or entity to which it is
addressed or the individuals designated to view such information per
federal HIPAA regulations. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately. ***
* **** ** ** ---------------------------------------------------------------------
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**** --
___________________________
Alvaro Cordero Retana
Consultor de Tecnologias
Gridshield Monitoreo de Redes e
Infraestructura.
2258-5757 ext 123
alvaro@gridshield.net
www.gridshield.net ---------------------------------------------------------------------
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
