How to create report from custom table what field has changed , who changed and when changed?

[Parshuram Walun]

Hi All, 

I am having custom table and having few fields. I want to create report from the custom table about  specific field  changed , who changed and when changed?

As I was trying to use sys_audit table , after enabling audit on table, however it is not recommended to use sys_audit table because it has large number of data as per service now doc.

How other developer are using such use cases or how they have created report out of such use case?

Looking forward for your help

thanks

Parshuram

[Parshuram Walun]

can you please provide me the business rule name which you are referring?

[Ahmmed Ali]

Note: In the base system, metrics are configured to work on the task table only. To apply metrics to cmdb_ci tables, duplicate the metric events business rule that currently runs on the task table for the cmdb_ci table. Without the events created, no metric processing can occur.

Same is mentioned in the Doc link I shared before: https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/use/reporting/task/create...