Additional Comments/Work Notes Issue after Clone

TStark
Kilo Sage

After cloning prod down to any sub-instance I've noticed that all of our Additional comments and Work notes (all activities) are showing as being submitted by the Requestor even though some of those comments/notes were submitted by the Assigned to. This occurs on both incident and request (more specifically the RITM as thats were we communicate). I've also noticed that the System activities such as Email sent aren't displayed in that same activities section. Has anyone else experienced these issues?

 

Thanks,
AJ

 

 

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

You probably excluded log and audit data? 

The activity stream and history of records is build up  from the records from the sys_audit table. When you clone, excluding the log/audit data simply deletes the sys_audit table. When you view a record, the journal fields in the sys_journal_field table are found, but there isn't an audit. 

By default, it will use the name of the record creator. 

 

If this is an issue (shouldn't be, since it's sub-prod and only used for testing/developing), you can run the clone again but without excluding it.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

1 REPLY 1

Mark Manders
Mega Patron

You probably excluded log and audit data? 

The activity stream and history of records is build up  from the records from the sys_audit table. When you clone, excluding the log/audit data simply deletes the sys_audit table. When you view a record, the journal fields in the sys_journal_field table are found, but there isn't an audit. 

By default, it will use the name of the record creator. 

 

If this is an issue (shouldn't be, since it's sub-prod and only used for testing/developing), you can run the clone again but without excluding it.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark