Hi Experts.
There is a requirement from the customer that they need to track all the changes in many tables such as person, skill, task, resource and etc and they expect to include all the fields in those tables in the fsm audit.
Could you please advice me is there any limitation that we can provide so that it will not be a performance issue?
Thanks,
Heshala.
Hi
if you want to track tables then you need to activate history logs for these tables.
You will only have performace issues if you want to retrieve all these logs with a quick report.
Maybe you need a IAL for the history logs because a non admistrator user can’t retrieve all history logs.
Test it at first on your test environment and limit the logs as much as possible.
Hi
You could always use audit function to track the changes happened in the selected columns of tables based on your requirement. But if you select all the columns of the table to audit, it could cause performance issues. It is good to discuss with the customer and identify the most critical data that they need to audit. Then you could only create audit based on that requirement to prevent any performance issues. Below document explains how to create an audit. Furthermore, refer below topic. Hope this may help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.