Database logging in D365FO

Hi,

In my previous post, I explained the steps involved in setting up the database log(for field Name of table BankGroup) and here I want to discuss the log cleaning up process, recording the logged events and generating database log report.

Step 1: Traverse to the database log form(Path: System administration > Inquiries > Database log) and clear the database logged events by clicking on Clean up log button. It's not mandatory to clear the log but for the demo purpose, I have cleared the logged events by specifying the criteria for log type to be Delete, Update and Insert on the Database log form.

Step 2: Navigated to the Bank groups form(Path: Cash and bank management > Setup > Bank groups) and created a bank group record with values as BG1 for field Bank groups and Bank Group 1 for field Name.  

Step 3: Modified the value of Name from Bank Group 1 to Bank Group 2 such that the update operation is logged.

Step 4: D365FO creates a record in database log form with Type of change as Update and updated values as Bank Group 2(as shown below).

Step 5: Also we can generate a database log report by specifying the criteria like Records to Include, Run in the background(i.e through batch with recurrence if needed). Click on the OK button to generate the report. 

Step 6: Report provides the timestamp of the update along with other details like Current value, previous value, Type of change, Created by and so on.

Regards,

Chaitanya