Document Key and Record Internal Checkpoint

jfnewell1965
Kilo Explorer

Hello,

The sys_audit table has two fields "Document Key" and "Record Internal Checkpoint".

I am trying to discover how I can leverage these to tie back to a particular CI.

An example I was thinking was search sys_audit for a particular table name where "New value" and "Old Value" are not equal, and then use "Document Key" and/or "Record Internal Checkpoint" to tie back to a CI.

Is this direction flawed? Any ideas how to implement?

Thanks in advance,
Jim

2 REPLIES 2

dmolnar101
Kilo Contributor

Did you ever find an answer for this? I am looking to track down the same thing.

Dan


If you go to your CI's and create an "update" import template you should receive a spreadsheet that contains all the sys id's for all the CI records on your template. You could then compare that to the document key...



This should allow you to reference audit records back to their respective CI's