Audit Policy Records all Changes in the Database Table when no Fields are Defined or when only Some are Defined
  • 10 Apr 2023
  • Contributors
  • Dark
    Light
  • PDF

Audit Policy Records all Changes in the Database Table when no Fields are Defined or when only Some are Defined

  • Dark
    Light
  • PDF

Article summary

When an audit policy is configured, it is noted that it will track all changes in the table regardless of what audit fields are defined for that table.

Answer:

The Audit Tables tab has a check box under the Table Details section for "1 record/field". If this is unchecked, the values will show on the Data Activity Auditing Report, but it will track all of the fields changed on the profile. If the 1 record/field box is checked, the values will show on the User Activity Auditing Report. Unfortunately, it will track all of the fields, not just the ones you designate.

The reports pull from different tables in FIMS based on what box is checked and typically everything is tracked especially for funds and profiles. Depending on your box selection this will determine what report should be run. This is a Progress feature that was enabled for FIMS use and as such you may want to review the Progress documentation on this feature.

Potentially at your discretion you could choose to delete or disable all of the audit policies in FIMS and setup auditing directly in Progress as it may give you more control over what data is tracked. It is recommended that you test any auditing in your Demo database first.

Progress documentation on Audit policies:
https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/gscsv/audit-policies.html

On the bottom of the article above it indicates to go to Start>Programs >OpenEdge > Help > Application Help on the server where Progress is installed to get to the Audit Policy Maintenance help where there is further documentation:

Progress documentation on setting up auditing in OpenEdge:
https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/gscsv%2Fauditing-in-openedge.html%23


Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.
 


Was this article helpful?