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 <dilsont...@gmail.com>* On Tue, Sep 25, 2012 at 12:45 PM, Andrew Meyer <ame...@precisionpractice.com > 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: ame...@precisionpractice.com**** > > ** ** > > *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@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 <alv...@gridshield.net> > wrote:**** > > 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 < > ame...@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: ame...@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 > alv...@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 >
<<image003.png>>
<<image002.png>>
<<image001.jpg>>
--------------------------------------------------------------------- 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