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.

 

Description: http://www.precisionpractice.com/EmailSignature/images/logoTeamLeader.jpg

D: 314-881-5265

Description: http://www.precisionpractice.com/EmailSignature/images/spacer.gif

C: 314-565-0868

Description: http://www.precisionpractice.com/EmailSignature/images/spacer.gif

F: 314-881-5365

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