Re: [otrs] Mysql Help

2012-09-25 Thread Dilson Tomé
; > Email: ame...@precisionpractice.com > > ** ** > > *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@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***

Re: [otrs] Mysql Help

2012-09-25 Thread Andrew Meyer
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 '

Re: [otrs] Mysql Help

2012-09-25 Thread Dilson Tomé
> > ** ** > > *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

Re: [otrs] Mysql Help

2012-09-25 Thread Andrew Meyer
:47 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Mysql Help Actually it migth take you about 1 hour or more. Be Patient. Regards On Tue, Sep 25, 2012 at 9:45 AM, Andrew Meyer mailto:ame...@precisionpractice.com>> wrote: Not working... I guess it might take some t

Re: [otrs] Mysql Help

2012-09-25 Thread Alvaro Cordero
M > *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,

Re: [otrs] Mysql Help

2012-09-25 Thread Andrew Meyer
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 mailto:alv...@gridshield.net>> wrote: Hello

Re: [otrs] Mysql Help

2012-09-25 Thread Muhammad El-Sergani
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 c

Re: [otrs] Mysql Help

2012-09-25 Thread 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.

Re: [otrs] Mysql Help

2012-09-25 Thread Leonardo Certuche
Hello Andrew, The Generic Agent is your friend on those cases http://doc.otrs.org/3.1/en/html/adminarea-genericagent.html Leonardo Certuche Medellín, Colombia On 25 September 2012 09:52, Andrew Meyer wrote: > I need to close about 25,000 tickets all with the same email address. I > was hopin

[otrs] Mysql Help

2012-09-25 Thread Andrew Meyer
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