Re: [otrs] delete tickets

[Alvaro Cordero]

Hello Eugene, that process is slow as you mention, when deleting it has to
go into several tables and delete all relations between objects before
deleting objects. If you are deleting all tickets and everything in the
system then the best way is to drop database and create it again, otherwise
best thing is wait, depending on the configuration of your machine that
might take you about 10-15 hours,

Best thing to do is configure generic agent to run every 10 o 20 minutes.
It deletes about 4000 tickets each round.

Regards.

2015-11-20 7:32 GMT-06:00 Eugene Polyanichko :

> Hi,
>
> i'm using old otrs 3.1.7 and there is around 170k tickets, that I need to
> delete. I'm using generic agent, but the process is VERY slow. It takes
> around 5-10 second to delete one ticket and there is actually no load on
> hardware (load average: 0.25, 0.20, 0.12), everything is idle. Are there
> any ways to make this process faster?
> -
> 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 RetanaConsultor de Tecnologias*
*Tel: 22585757 ext 123*
*Email:* alv...@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

Re: [otrs] delete tickets

[Eugene Polyanichko]

  
  
Thanks a lot for reply!
  
  On 20.11.2015 16:31, Alvaro Cordero wrote:


  

  Hello Eugene, that process is slow as you mention, when
deleting it has to go into several tables and delete all
relations between objects before deleting objects. If you
are deleting all tickets and everything in the system then
the best way is to drop database and create it again,
otherwise best thing is wait, depending on the configuration
of your machine that might take you about 10-15 hours, 

  
  Best thing to do is configure generic agent to run every 10 o
  20 minutes. It deletes about 4000 tickets each round. 
  

Regards. 
  
  
2015-11-20 7:32 GMT-06:00 Eugene
  Polyanichko :
  Hi,

i'm using old otrs 3.1.7 and there is around 170k tickets,
that I need to delete. I'm using generic agent, but the
process is VERY slow. It takes around 5-10 second to delete
one ticket and there is actually no load on hardware (load
average: 0.25, 0.20, 0.12), everything is idle. Are there
any ways to make this process faster?
-
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] delete tickets

[Eugene Polyanichko]

Hi,

i'm using old otrs 3.1.7 and there is around 170k tickets, that I need 
to delete. I'm using generic agent, but the process is VERY slow. It 
takes around 5-10 second to delete one ticket and there is actually no 
load on hardware (load average: 0.25, 0.20, 0.12), everything is idle. 
Are there any ways to make this process faster?

-
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

Re: [otrs] Delete tickets

[Andy Wodfer]

Ok, thanks! I created a generic agent and it seems to work.

Cheers,
Andy


On Tue, Aug 24, 2010 at 10:45 PM, Nathan Campbell n.campb...@dalsym.comwrote:

  I go about it like this – I’ve created a queue named Trash and anything
 that I want to be deleted and never seen or thought of again is move to that
 queue.

 Then, I created a GenericAgent job that deletes anything in the Trash queue
 every 10mn. For me, that is good enough.

  I also have GenericAgents that run that identify and move emails with
 Subjects ‘Out of Office’ or ‘Undeliverable’ to the Trash queue as well.


 Hope that helps,



 *Nathan Campbell*
 Dallas Symphony Orchestra


  *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf
 Of *Andy Wodfer
 *Sent:* Tuesday, August 24, 2010 2:43 PM
 *To:* otrs@otrs.org
 *Subject:* [otrs] Delete tickets



 Hi,

 I'm a newbie to OTRS (just started using it today). I don't understand how
 I can delete tickets?

 In my Dashboard under New tickets I receive some junk emails and I want to
 delete them right away. Is there a simple way of doing this?

 If I just move them to the JUNK folder they still appear under New tickets.

 Sorry for this newbie question, but hopefully someone could give me some
 help here.

 Cheers!

 Andy

 -
 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] Delete tickets

[Andy Wodfer]

Hi,
I'm a newbie to OTRS (just started using it today). I don't understand how I
can delete tickets?

In my Dashboard under New tickets I receive some junk emails and I want to
delete them right away. Is there a simple way of doing this?

If I just move them to the JUNK folder they still appear under New tickets.

Sorry for this newbie question, but hopefully someone could give me some
help here.

Cheers!

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

Re: [otrs] Delete tickets

[Ray Padilla]

I need this information as well. thanks

Ray Padilla
Director of Information Technology
ray.padi...@paquinhealthcare.commailto:ray.padi...@paquinhealthcare.com
407-566-1010, ext 223
Paquin Healthcare Companies
1142 Celebration Blvd
Celebration, Florida 34747

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Andy 
Wodfer
Sent: Tuesday, August 24, 2010 3:43 PM
To: otrs@otrs.org
Subject: [otrs] Delete tickets

Hi,
I'm a newbie to OTRS (just started using it today). I don't understand how I 
can delete tickets?

In my Dashboard under New tickets I receive some junk emails and I want to 
delete them right away. Is there a simple way of doing this?

If I just move them to the JUNK folder they still appear under New tickets.

Sorry for this newbie question, but hopefully someone could give me some help 
here.

Cheers!

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

Re: [otrs] Delete tickets

[Nathan Campbell]

I go about it like this - I've created a queue named Trash and anything that I 
want to be deleted and never seen or thought of again is move to that queue.
Then, I created a GenericAgent job that deletes anything in the Trash queue 
every 10mn. For me, that is good enough.

I also have GenericAgents that run that identify and move emails with Subjects 
'Out of Office' or 'Undeliverable' to the Trash queue as well.

Hope that helps,

Nathan Campbell
Dallas Symphony Orchestra


From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Andy 
Wodfer
Sent: Tuesday, August 24, 2010 2:43 PM
To: otrs@otrs.org
Subject: [otrs] Delete tickets

Hi,
I'm a newbie to OTRS (just started using it today). I don't understand how I 
can delete tickets?

In my Dashboard under New tickets I receive some junk emails and I want to 
delete them right away. Is there a simple way of doing this?

If I just move them to the JUNK folder they still appear under New tickets.

Sorry for this newbie question, but hopefully someone could give me some help 
here.

Cheers!

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

Re: [otrs] Delete tickets

[Alan]

This is from yesterday:

http://lists.otrs.org/pipermail/otrs/2010-August/033198.html


On Wed, Aug 25, 2010 at 5:45 AM, Nathan Campbell n.campb...@dalsym.com wrote:
 I go about it like this – I’ve created a queue named Trash and anything that
 I want to be deleted and never seen or thought of again is move to that
 queue.

 Then, I created a GenericAgent job that deletes anything in the Trash queue
 every 10mn. For me, that is good enough.

 I also have GenericAgents that run that identify and move emails with
 Subjects ‘Out of Office’ or ‘Undeliverable’ to the Trash queue as well.

 Hope that helps,



 Nathan Campbell
 Dallas Symphony Orchestra


 From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Andy
 Wodfer
 Sent: Tuesday, August 24, 2010 2:43 PM
 To: otrs@otrs.org
 Subject: [otrs] Delete tickets



 Hi,

 I'm a newbie to OTRS (just started using it today). I don't understand how I
 can delete tickets?

 In my Dashboard under New tickets I receive some junk emails and I want to
 delete them right away. Is there a simple way of doing this?

 If I just move them to the JUNK folder they still appear under New tickets.

 Sorry for this newbie question, but hopefully someone could give me some
 help here.

 Cheers!

 Andy
 -
 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] DELETE tickets

[BALAN, Daniel]

I am using the Delete tickets option option in order to clear the Spam
messages our antispam filters.

In the OTRS manual is written:

Example for Kernel/Config/GenericAgent.pm
[...]
# --
# [name of job] - close and delete all tickets in queue delete
# --
'delete' = {
# get all tickets with this properties
Queue = 'delete',
States = ['new', 'open'],
Locks = ['unlock'],
# new ticket properties (no option is required, use just the options
# witch should be changed!)
New = {
# DELETE!
Delete = 1,
},
},
[...]

I would like to know what really happens in the DB when Delete = 1.
Only the records in the ticket table are deleted? What about the article
table?

Thanks,
Daniel 



-- 
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://www.bitdefender.com/

___
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
Support oder Consulting für Ihr OTRS System?
= http://www.otrs.de/

[otrs] Delete tickets from Custom Queue

[Ravi Teja]

  I am newbie for OTRS. could somebody help me with 
  this.
  
  How can i delete the tickets which are present in 
  the Queue (for eg. 'customer service').
  Can it be done from the selectbox by writing the 
  query ? if so please tell me the query or is there any other options 
  ?
  
  Thanks in advance.
  
  --RT
___
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
Support oder Consulting für Ihr OTRS System?
= http://www.otrs.de/

Re: [otrs] Delete tickets from Custom Queue

[Pim Rupert (Lemonbit)]

How can i delete tickets


There is  not a delete this ticket function, *ofcoarse not*. That's  
one of the beauty features of OTRS. :-)


If you really want to delete tickets you can create a job for this.  
For example, I have created a queue 'Spam' in which possible spam  
tickets are moved. Every night a job runs to delete all the tickets  
in the Spam queue. If I want to remove a ticket, I just simply move  
it to the Spam queue.


--
kind regards,
Pim Rupert
Lemonbit Internet

___
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
Support oder Consulting für Ihr OTRS System?
= http://www.otrs.de/