Database logging setup in D365FO

Hi,

Database logging is a feature in D365FO which helps us to track inserts, updates, and deletes on the intended tables provided if we are fine with the overhead of extra logging for every database operation on enabled tables. In this post, I want to discuss different steps involved in its set up while trying to enable database logging for field Name of table BankGroup.

Step 1: In D365FO, navigate to the path System Administration > Setup> Database log setup to launch the setup form. Please check the list of tables, fields, and type of change for which the database logging is enabled. If the required table is not listed, we can click on the new button which launches the database log wizard.

Step 2:  Click on the Next button to view the tables.

Step 3: On clicking Next button, the log wizard displays the list of modules(segregated logically). Please mark the checkboxes "Show all tables" and "Show table names" to display all the names of the tables instead of their labels.

Step 4: I am interested to log update operations that are going to be performed on BankGroup table. So, traversed to the path Bank > BankGroup and selected field Name and clicked Next button.

Step 5: Selected the field Name of table Bank groups and marked the checkbox under the update column. Click Next.

Step 6: Log wizard launches the page that displays the count of logging selected for every database operation. Click on Finish button to close the wizard.

Step 7: D365 provides messages to remind the performance impact on some tables. Below screenshot is one example of those. Click on Yes button to proceed further.

Step 8: We can see a record created for Name field of table Bank groups for the update operation in database log setup form.

Step 9: Enabling database log on a table creates a trigger on the backend. The same thing can be confirmed by checking the triggers node of table BankGroup in SSMS(SQL Server Management Studio). 

Regards,

Chaitanya Golla