Modifying some contents in History

RT Users
1

Hello,

We have users they have mentioned confidential information in RT.
Now I need just to anonymize these information in the Ticket History.

I’ve identified the transaction Id and now I how can I decode et re-encode the Content value located in the Attributes table

Example :

ConfidentialData --> xxxxxxxxxx

Our config :

  •  RT 4.2.12

  •  MySQL

Thanks in advance for your help.
Horst

Note Importante: Le contenu de ce courriel est uniquement réservé à la personne ou l’organisme à qui il est destiné. Si vous n’êtes pas le destinataire prévu, veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de l’utiliser de quelque manière que ce soit.

Important Notice: The content of this e-mail is intended only and solely for the use of the named recipient or organization. If you are not the named recipient, please inform us immediately and delete the present e-mail. In this case, you are not allowed to copy, distribute or use this e-mail in any way.

2

Hi,

It is easier to just use the Shredder to delete the transaction
from the system.

Regards,
KenOn Mon, Nov 28, 2016 at 02:32:17PM +0000, Kriegers Horst wrote:

Hello,

We have users they have mentioned confidential information in RT.
Now I need just to anonymize these information in the Ticket History.

I’ve identified the transaction Id and now I how can I decode et re-encode the Content value located in the Attributes table

Example :

ConfidentialData → xxxxxxxxxx

Our config :

  •  RT 4.2.12

  •  MySQL

Thanks in advance for your help.
Horst

Note Importante: Le contenu de ce courriel est uniquement réservé à la personne ou l’organisme à qui il est destiné. Si vous n’êtes pas le destinataire prévu, veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de l’utiliser de quelque manière que ce soit.

Important Notice: The content of this e-mail is intended only and solely for the use of the named recipient or organization. If you are not the named recipient, please inform us immediately and delete the present e-mail. In this case, you are not allowed to copy, distribute or use this e-mail in any way.

RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training

  • Los Angeles - January 9-11 2017
3

Hi,

Thanks for your reply.
I know this is the easiest way, but it is not acceptable in our case

Regards,
Horst

-----Message d’origine-----
De : Kenneth Marshall [mailto:ktm@rice.edu]
Envoyé : lundi 28 novembre 2016 16:33
À : Kriegers Horst Horst.Kriegers@loro.ch
Cc : ML - rt-users rt-users@lists.bestpractical.com
Objet : Re: [rt-users] Modifying some contents in History

Hi,

It is easier to just use the Shredder to delete the transaction from the system.

Regards,
Ken

Hello,

We have users they have mentioned confidential information in RT.
Now I need just to anonymize these information in the Ticket History.

I’ve identified the transaction Id and now I how can I decode et
re-encode the Content value located in the Attributes table

Example :

ConfidentialData → xxxxxxxxxx

Our config :

  •  RT 4.2.12

  •  MySQL

Thanks in advance for your help.
Horst

Note Importante: Le contenu de ce courriel est uniquement réservé à la personne
ou l’organisme à qui il est destiné. Si vous n’êtes pas le destinataire prévu, veuillez
nous en informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous
est pas permis de copier ce courriel, de le distribuer ou de l’utiliser de quelque
manière que ce soit.

Important Notice: The content of this e-mail is intended only and solely for the
use of the named recipient or organization. If you are not the named recipient,
please inform us immediately and delete the present e-mail. In this case, you are
not allowed to copy, distribute or use this e-mail in any way.

RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training

  • Los Angeles - January 9-11 2017

Note Importante: Le contenu de ce courriel est uniquement réservé à la personne ou l’organisme à qui il est destiné. Si vous n’êtes pas le destinataire prévu, veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de l’utiliser de quelque manière que ce soit.

Important Notice: The content of this e-mail is intended only and solely for the use of the named recipient or organization. If you are not the named recipient, please inform us immediately and delete the present e-mail. In this case, you are not allowed to copy, distribute or use this e-mail in any way.

4

Hi,

Thanks for your reply.
I know this is the easiest way, but it is not acceptable in our case

Regards,
Horst

Hi Horst,

When the shredder runs, it generates a SQL file to reconstitute the
deleted item when run. You could run shredder and then edit the SQL
file to obfuscate the needed items. Then run the resulting file to
re-add the now cleaned up item back into the system.

Regards,
Ken

5

Hi Ken,
Thanks for your reply.
It’s works like a charm :slight_smile:

Regards,
Horst

-----Message d’origine-----
De : Kenneth Marshall [mailto:ktm@rice.edu]
Envoyé : lundi 28 novembre 2016 17:09
À : Kriegers Horst Horst.Kriegers@loro.ch
Cc : ML - rt-users rt-users@lists.bestpractical.com
Objet : Re: [rt-users] Modifying some contents in History

Hi,

Thanks for your reply.
I know this is the easiest way, but it is not acceptable in our case

Regards,
Horst

Hi Horst,

When the shredder runs, it generates a SQL file to reconstitute the deleted item
when run. You could run shredder and then edit the SQL file to obfuscate the
needed items. Then run the resulting file to re-add the now cleaned up item back
into the system.

Regards,
Ken

Note Importante: Le contenu de ce courriel est uniquement réservé à la personne ou l’organisme à qui il est destiné. Si vous n’êtes pas le destinataire prévu, veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de l’utiliser de quelque manière que ce soit.

Important Notice: The content of this e-mail is intended only and solely for the use of the named recipient or organization. If you are not the named recipient, please inform us immediately and delete the present e-mail. In this case, you are not allowed to copy, distribute or use this e-mail in any way.