Re: [otrs] Mysql Help

[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
<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

<<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