Document Key and Record Internal Checkpoint

jfnewell1965
Kilo Explorer

‎01-19-2012 11:44 AM

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

0 Helpfuls
  • 4,475 Views
2 REPLIES 2

dmolnar101
Kilo Contributor

‎03-05-2013 08:30 AM

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

Dan


0 Helpfuls

dmixer
Mega Contributor
In response to dmolnar101

‎08-11-2015 07:58 AM

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


0 Helpfuls