Audit Logging - Primary fields/tables

(1) Share

Report

Posted on by MS-29042149-0

Hi, are there any primary tables/fields that audit logging should be switched on for in Finance and Supply Chain or is this up to the discretion of the company?

Also, the ideal time for how long logs should be retained? I understand if they aren't cleaned regularly then it could lead to performance issues

Thanks

Categories:

Administration and Setup

BI and Analytics

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 290,246 Super User 2024 Season 2 on at

Like (1)

Report

Audit Logging - Primary fields/tables

Hi,

There are several audit logs already stored in several tables, like who posted what accounting entries on what date. What additionally should be tracked depends on regulations in your country or requirements from e.g. GxP.

The retention period then also depends on specific requirements. Adding records to the database log isn't a huge performance killer. Once the database log is too large and you want to clean up the data, then it will take a long time. Next to that, the database log will consume the database capacity included in your subscription.