RTx::Shredder related question

Hi

I am trying to use RTx::Shredder to delete tickets that are in 'deleted’
status.

However when I run the command as

rtx-shredder 2004-07-22

I get Tickets list empty. But when I look for the deleted tickets in
mysql using the command

select count(*) from Tickets where status = ‘deleted’;

I get 120

What am I doing wrong?

Thanks
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There’s no place like 127.0.0.1

Asif Iqbal wrote:

Hi

I am trying to use RTx::Shredder to delete tickets that are in 'deleted’
status.

However when I run the command as

rtx-shredder 2004-07-22

I get Tickets list empty. But when I look for the deleted tickets in
mysql using the command

select count(*) from Tickets where status = ‘deleted’;

I get 120

What am I doing wrong?
You should apply patch to your RT instance. Current RT API implentation
doesn’t allow fetch deleted tickets. This only add flag to RT::Tickets
objects and Shredder use it.

			Best regards. Ruslan.

Ruslan U. Zakirov wrote:

Asif Iqbal wrote:

Hi

I am trying to use RTx::Shredder to delete tickets that are in 'deleted’
status.

However when I run the command as

rtx-shredder 2004-07-22

I get Tickets list empty. But when I look for the deleted tickets in
mysql using the command

select count(*) from Tickets where status = ‘deleted’;

I get 120

What am I doing wrong?
You should apply patch to your RT instance. Current RT API implentation

Is there one available out in public?

doesn’t allow fetch deleted tickets. This only add flag to RT::Tickets
objects and Shredder use it.

  		Best regards. Ruslan.

Thanks

Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There’s no place like 127.0.0.1

Asif Iqbal wrote:

Ruslan U. Zakirov wrote:

Asif Iqbal wrote:

Hi

I am trying to use RTx::Shredder to delete tickets that are in 'deleted’
status.

However when I run the command as

rtx-shredder 2004-07-22

I get Tickets list empty. But when I look for the deleted tickets in
mysql using the command

select count(*) from Tickets where status = ‘deleted’;

I get 120

What am I doing wrong?

You should apply patch to your RT instance. Current RT API implentation

Is there one available out in public?
Yes, it’s distributed with RTx-Shredder. Also it was sent to rt-devel.
There is two versions in rt-devel you should use second one.
Best regards. Ruslan.

Ruslan U. Zakirov wrote:

Is there one available out in public?
Yes, it’s distributed with RTx-Shredder. Also it was sent to rt-devel.
There is two versions in rt-devel you should use second one.
Best regards. Ruslan.

Ruslan, are you planning to use ItemMap or some other key/value to display
the ticket numbers–that are in deleted status–in stdout?

It will help to log all the ticket numbers that got deleted. Just for
pure logging purpose and may be make that optional.

The RTx:Shredder::Dependency or Dependencies gotcha is what you
currently have in stdout.

Also is there a way to use shell level exit status with rtx-shredder.
The reason I am asking this is if I run it from cron I like the
success redirected to a file but any failures trigger an email.

Thanks for such an excellent script

It worked for me exactly as it suppose to work
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There’s no place like 127.0.0.1

Asif Iqbal wrote:

Ruslan U. Zakirov wrote:

Is there one available out in public?

Yes, it’s distributed with RTx-Shredder. Also it was sent to rt-devel.
There is two versions in rt-devel you should use second one.
Best regards. Ruslan.

Ruslan, are you planning to use ItemMap or some other key/value to display
the ticket numbers–that are in deleted status–in stdout?
This info is reported to RT log with warning level.
I can mirror it to STDOUT & STDERR and it’s on my TODO list.

It will help to log all the ticket numbers that got deleted. Just for
pure logging purpose and may be make that optional.
As I say it’s logged into RT log.

The RTx:Shredder::Dependency or Dependencies gotcha is what you
currently have in stdout.
Yay, I know, it was commited by incedent when I was descovering memory
footprint.

Also is there a way to use shell level exit status with rtx-shredder.
The reason I am asking this is if I run it from cron I like the
success redirected to a file but any failures trigger an email.
I’ll think about it.

Thanks for such an excellent script

It worked for me exactly as it suppose to work
Glad to hear it.

				Good luck. Ruslan.