Create report with table 'sys_audit' and display meaningful value instead of ID
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.