Enabling Database Log in D365FO

Database logging provides a way to track specific types of changes to the tables and fields in the system. Changes that can be tracked include insert, update, delete, and rename key operations.

When you configure logging for a table or field, a record of every change to that table or field is stored in the database log table, sysdatabaselog, in the environment database.

Please note Database logging is intended to track individual transactions. It isn’t intended to track automated transactions that are run in batch jobs.

In this post , let us understand how to enable database log.

Navigate to System Adminstration -> Set up -> Database log -> Database log set up

A wizard opens upon clickin ‘New’

An alert is displayed to perform the action during non-business hours.

Click Yes

Click Next. It takes few minutes to load the next screen as all the tables will be displayed.

Click on ‘Show all tables’ and ‘Show Table names’ if you are familiar with the table names which needs the log enabled.

In our use case, let us enable the Electronic contact – Email address field to be tracked.

Do Ctrl+F and enter ‘LogisticsElectronic’ and the matching phrase will be highlighted

Select the Table and enable the fields which are needed.

Click Next.

Select the ‘Update’ check box for the table which was selected in the previous step.

Click Next and Finish the wizard.

Now the database log is ready to capture the changes.

To monitor the log, Navigate to System Adminstration -> Inquiries -> Database -> Database Log

I have made a change in the email address of a customer. Values are captured here.

Thus any updates made in the email across the system are captured.

Note:

The database log table can grow fast and can increase the database size. The amount of growth depends on the amount of logged data that is to be retained.

Original Post https://anithasantosh.wordpress.com/2025/10/14/enabling-database-log-in-d365fo/