Parag Chapre

Database logging in Dynamics 365 HR and Finance & Operations

Spread the love

Database logging in Dynamics 365 Human Resources and Finance & Operations is a history of actions executed by the system, based on CRUD (Create Update Delete). Database logging is needed to track the specific types of changes to the system. The operations that can be tracked with database logging are: insert, update, delete and rename key.

When we configure the logging for a table or field, a record of every change to that table or field is stored in the database log table called sysdatabaselog, located in the environment database. Database logging can be used to create an auditable record of changes to specific tables that contain sensitive information.

How to setup database logging

1. Go to System administration > Links > Database > Database log setup.

Database logging step 1

2. Select New.
3. Click Next.

It will show the tables and their field names. If you click on Show all tables and Show table names, then it will display technical names for the tables and fields. You will see something like this:

Database logging D356 HR

4. Select Position details and click on Next.

AX 2012 data logging

5. Mark the checkbox for Insert, update and delete operationClick on Next.

Dynamics 365 Talent Database logging

6. Finish the wizard.

D365 Data logging

Once the setup is finished, it will show the desired operations in the setup form.

D365 Talent F&O Database logging

Now, lets test it

Now we have to create a position and add some information to Position details.

D365 data logging

1. Add some data to Position details as listed below and complete the position action.

D365 data logging

2. Now, If you go to System Admin > Links > Database log, A new record is created for Insert operation.

D365 data logging FO

3. Go back to the Position and change some details of Position. Complete the Position action.

D365 data logging

4. Now, If you go to System Admin > Links > Database log, a new record is created for Update operation.

D365 technical knowledge

5. Go back to the Position and delete it.

D365 data logging Talent

6. Now, the Position is deleted. Go to System Admin > Links > Database log. A new record is created for Delete operation.

D365 data logging Talent F&O

The history of the table can be tracked using Database Log > History tab. It will show the event fired during the Position life cycle.

How to clean up the database logs

Lastly, we will show you how to clean up your database logs.

  1. Go to System administration > Inquiries > Database > Database log.
  2. Select Clean up log.
Dynamics 365 Talent

3. The clean-up can be done in a batch or manual depending on data.

Data logging for Dynamics Talent 2

4. Once this is done, it will show blank data in Database log form.

Data logging for Dynamics Talent 3

In this way we can track the information of sensitive data.

For more information check Microsoft docs. If you have any other questions, feel free to reach out to us via our live chat in the bottom right of your screen. Click here to learn more about our solutions that enhance Dynamics 365 Human Resources.

Leave a Reply

Your email address will not be published. Required fields are marked *