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

[OlaN]

Hi,

One way to solve this, is to create additional specific field on this custom table, that sets the date and updated by whenever a specific field is changed.

However, this solution will not be optimal on a larger scale, if you have many fields you want to track in this manner.

[Ahmmed Ali]

Hello @Parshuram Walun 

I would use the metric functionality for this use case. Create new Metric Definition on your custom table and for the field. 

If your custom table does not extend task table, then you will need to clone metric related Business Rule/s to tour custom table.

Refer: https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/use/reporting/task/create... 

Thanks,

Ali

[Parshuram Walun]

Hello @Ahmmed Ali , my table is custom table and i don't want to extend to other table.

What are the other ways?

[Ahmmed Ali]

Hello @Parshuram Walun 

Even though the table is custom and not extending task, you can still use the Metric functionality. You just have to duplicate the Business rule mentioned in the Docs in your custom table.

Thanks,

Ali