What is the real use of sys_audit_relation table

raghavendramami
ServiceNow Employee
ServiceNow Employee

‎11-25-2016 02:22 AM

What is the best approach to maintain this table like rotation / Archive etc..We have huge number of records in this table.

Any impact by implementation of rotation on this table?

0 Helpfuls
  • 1,497 Views
1 REPLY 1

india
Tera Guru

‎11-25-2016 02:38 AM

Hi,


check out the link below



https://community.servicenow.com/thread/175774



And as per my opinion never go for rotation ...for this table


its good to be archive it.




Regards'


Kirtesh



Pls mark as correct/helpful/like if you feel so;-)


sys_audit_relation = "Audit Relationship Change"



I believe that the sys_audit_relation table tracks changes to reference fields (sys_ids).


Per record there is a document key and table ( = context), "Audit" and "Audit Delete" fields.



"Audit Delete" -> Reference to sys_audit_delete (records that have been deleted).



"Audit" -> Reference to sys_audit table (all changes).


All these sys_audit references listed in the sys_audit_relation table have sys_id values for "old" and/or "new" values. Therefore, the sys_audit_relation focus on tracking sys_id changes throughout the system and utilises sys_audit and sys_audit_delete tables to do so. It is most likely a kind of caching or "quick reference" table used by the system.



0 Helpfuls