After a clone, the Activities log shows the correct comments and work notes but not the correct user who made them.

Marshall Day · ‎09-22-2017

After a clone, the Activities log shows the correct comments and work notes on Incidents but not the correct user who made them. Any ideas to correct this would be greatly appreciated.

Marshall Day · ‎11-22-2017

Earl,

I did receive some info from HI but the answer was not exactly what I wanted to hear. There is no real issue with the bringing over of the sys_audit table as far as time is concerned. Since the data is pulled before the clone there isn't a huge delay in the cloning. The issue was one of security. We have many, as probably most companies, secure incidents that deal with either personal info or HR type info. The information that is secure is stored in the same tables that the activity logs are stored so that was the reason we weren't bringing those tables over to begin with. There is no way to separate the secure data from the unsecured data in the cloning process.

So after a long discussion with our BA team it was decided that not importing secure data was more important than having the correct user ID on records that were in a non-production instance.

I hope this answers any questions you may have.

Marshall

View solution in original post

sethivarun · ‎09-22-2017

Hey Marshall,

did you check Exclude Audit data while cloning?

If yes, then this is expected

Marshall Day · ‎09-22-2017

Varun,

Thanks for the response.

Yes, we have the Exclude Audit data checked. But this is the direction of the question. The sys_audit table is excluded, along with many others. If the clone is excluding the audit table, which pulls from the history and journal fields, how come the comments and work notes are being transferred but not who made the comments or work notes? This is what I am trying to get my head around.

Marshall

Chandu Telu · ‎09-23-2017

HI Marshall,

Can you check the user id/user name is same in two instances

sethivarun · ‎09-25-2017

Hey Marshall,

That's what happened to us. Somehow the comments and other journal things do get transferred but the user info doesn't . If i am not wrong, as of now it would be showing that the comments and worknotes were made by the same user who made the very first comments, correct?

I had an article that explained this, i will do some digging around and suggest.

Meanwhile do raise an HI ticket.