Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. Request Tracker>
  3. Users
Modifying some contents in History
Horst.Kriegers at loro
Nov 28, 2016, 6:32 AM
Post #1 of 5 (1166 views)
Permalink
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.

________________________________
Re: Modifying some contents in History [ In reply to ]
ktm at rice
Nov 28, 2016, 7:33 AM
Post #2 of 5 (1160 views)
Permalink
Hi,

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

Regards,
Ken

On 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

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Modifying some contents in History [ In reply to ]
Horst.Kriegers at loro
Nov 28, 2016, 7:43 AM
Post #3 of 5 (1160 views)
Permalink
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
>
> On 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


________________________________
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
Re: Modifying some contents in History [ In reply to ]
ktm at rice
Nov 28, 2016, 8:09 AM
Post #4 of 5 (1160 views)
Permalink
On Mon, Nov 28, 2016 at 03:43:01PM +0000, Kriegers Horst wrote:
> 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
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Modifying some contents in History [ In reply to ]
Horst.Kriegers at loro
Nov 28, 2016, 11:30 PM
Post #5 of 5 (1148 views)
Permalink
Hi Ken,
Thanks for your reply.
It's works like a charm :)

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
>
> On Mon, Nov 28, 2016 at 03:43:01PM +0000, Kriegers Horst wrote:
> > 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.

________________________________
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal