How To Track Audit Trail Attribute Changes

Products

• Clarity PPM On Premise

Issue/Introduction

The global right(Audit Trail - Access) provides resources the ability to select the operations of insert,deletion, and changes of object attributes/fields

Resolution

The results of the following query can be reviewed to find out who made changes and when:

select * from ODF_AUDITED_ATTRIBUTES
order by object_code, last_updated_date desc;

Additional Information

When object attributes are added for auditing, an update is made to the ODF_AUDITED_ATTRIBUTES table.

When object attributes are removed for auditing, an update is not made.

Audited attributes (current or previously audited) will persist in the users view on the [object] > Audit Trail tab.

To remove rows from the Audit Trail page or purge the audit data from the database you can enter a specific number of days

1. Go to Clarity >Object > Purge Audit Trail > Days (check with the business since purging will be decision that drives the use of the Purge Audit Trail feature)
2. Run the Clarity job called Purge Audit Trail

Attribute insertions, deletions, and changes can be audited.
In the event that the prior value and new value appears blank, reset the available attribute and click Save.