Re: [otrs] Mysql Help

[Alvaro Cordero]

Actually it migth take you about 1 hour or more.

Be Patient.

Regards

On Tue, Sep 25, 2012 at 9:45 AM, 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
>



-- 
___________________________
Alvaro Cordero Retana
Consultor de Tecnologias
Gridshield Monitoreo de Redes e
Infraestructura.
2258-5757 ext 123
alv...@gridshield.net
www.gridshield.net

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