I vote for Generic Agent as well. Works very good. Thanks //M On Tue, Sep 25, 2012 at 4:57 PM, Alvaro Cordero 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 < 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.*****

** **

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

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

Actually it migth take you about 1 hour or more. Be Patient. Regards On Tue, Sep 25, 2012 at 9:45 AM, Andrew Meyer 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: ameyer@precisionpractice.com****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@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 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 < 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.*****

****

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

--------------------------------------------------------------------- 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 alvaro@gridshield.net www.gridshield.net

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 * On Tue, Sep 25, 2012 at 12:45 PM, Andrew Meyer

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: ameyer@precisionpractice.com****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@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 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 < 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.*****

****

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

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

You can query this: mysql -u *otrs* -p*hot* * * mysql> use *otrs*; mysql> select count(id) from ticket; +-------------+ | count(id) | +-------------+ | 18 | +-------------+ 1 row in set (0.00 sec) --! *Dilson Tomé Rainov * On Tue, Sep 25, 2012 at 6:00 PM, Andrew Meyer wrote:

Did you just take the defaults? Its been almost 5 hours and still 25K in there…****

** **

Andrew Meyer****

*Precision Practice Management*****

T:314-787-0681 D: 314-881-5265 C: 314-565-0868 F: 314-881-5365****

Email: ameyer@precisionpractice.com****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Dilson Tomé *Sent:* Tuesday, September 25, 2012 10:53 AM

*To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Mysql Help****

** **

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

****

On Tue, Sep 25, 2012 at 12:45 PM, Andrew Meyer < AMeyer@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: ameyer@precisionpractice.com****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@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 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 < 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.*****

****

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

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

** **

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