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 >
<<image003.png>>
<<image001.jpg>>
<<image002.png>>
--------------------------------------------------------------------- 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