Nee to create report when fields are updated

[Chiranjeevi K]

Hello All, 

We have a requirement to create a report when the fields are updated on the record with old value, new value and updated by details and we have created the database view of our two tables (contract table & Sys_audit table) which shows the all available records of the contract with old value, new value and updated by details instead of updated records

we are looking to pull only the records that are updated as per our mentioned time period over the filter in the report table.

I have read somewhere e that sys_audit table will create records only when we open from the history of the record which is limiting us from pulling the report or there is something to do with where clause on the database view.

looking forward for the help with your expertise to achieve this, thanks in advance!!

[Tanushree Maiti]

Hi @Chiranjeevi K 

Querying the sys_audit table directly can cause performance issues due to its size. For high-volume reporting, consider using Metrics (metric_instance table) to track specific field changes instead.

Refer KB: https://noderegister.service-now.com/kb?id=kb_article_view&sysparm_article=KB1640696