Create report with table 'sys_audit' and display meaningful value instead of ID

MB Ng
Tera Contributor

‎05-15-2023 09:06 PM

Hi Experts,

 

Created an report with table 'sys_audit' but how to show the actual value?

e.g. Table name = cmdb_ci_computer

Document Key display as CI name, Old/New value as people name instead.

 

MBNg_0-1684209814775.png

 

0 Helpfuls
  • 1,030 Views
1 REPLY 1

Dan_Kane
ServiceNow Employee
ServiceNow Employee

‎07-06-2023 06:45 AM

Hi,

 

It is not advisable to run reports on the sys_audit table, or any other system table (tables that begin with sys_). If you would like to track field changes in a table, use platform Metrics. The docs page indicates they can only be used on ITSM tables, but they can be setup to run against any non-system table in the platform.

0 Helpfuls