Configure and manage database logging
The functionality noted in this article is currently available for customers on the stand-alone Dynamics 365 Human Resources. Some or all of the functionality will be available as part of a future release on the Finance infrastructure after Finance release 10.0.25.
Applies to these Dynamics 365 apps:
You can track changes to tables and fields in Dynamics 365 Human Resources with database logging. This article describes how to:
- Manage security and performance for database logging
- Set up database logging
- Clean up database logs
Overview of database logging
Database logging tracks specific changes to Microsoft Dynamics 365 Human Resources tables and fields. These changes include inserting, updating, or deleting. Database logging stores a record of changes to tables or fields in the database log table.
The business uses of database logging include:
- Creating an audit record of changes to specific tables that contain sensitive information.
- Tracking single transactions. Database logging isn't intended for tracking automated transactions that run in batch jobs.
Security for database logging
Database logs can contain sensitive data. Limit access to include only security roles that need access to the log data.
Database logging and performance
While valuable from a business perspective, database logging can be expensive in resource use and management. The performance implications of database logging include:
The database log table can grow quickly and cause an increase in the size of the database. Growth depends on the amount of logged data that you decide to keep. By default, the database log table maintains only 30 days of log data.
Database logging can adversely affect long-running automated processes, such as long-running data imports.
To improve performance, limit log entries by selecting specific fields to log instead of whole tables. To help maintain overall performance, database logging is limited to 20 tables.
Only updates can be logged for individual fields.
Set up database logging
You can use the Logging database changes wizard to set up database logging. The wizard provides a flexible way to set up logging for tables or fields.
Go to System administration > Links > Database > Database log setup. Select New to start the Logging database changes wizard.
On the Tables and fields page of the wizard, select the the tables and fields on which you want to enable database logging, and select Next.
Database logging is not available on all tables in the Human Resources database. Selecting Show all tables below the list expands the list of tables and fields to show all database tables for which database logging is available, but this will be a subset of the full list of database tables.
On the Types of change page of the wizard, select the data operations for which you want to track changes for each of the tables and fields, and select Next. See the table below for a description of the data operations that are available for logging.
On the Finish page, review the changes that will be made, and select Finish.
|Track new transactions||Create a log for new records that are created in the table.|
|Update||Create a log for updates to table records, or updates to individually selected fields in the table. If you select to log updates for the table, then a log record is created each time an update is made to any field of any record on the table. If you select to log updates for specific fields, then a log record is created only when updates are made to those fields of table records.|
|Delete||Create a log for records deleted from the table.|
|Rename key||Create a log record when a table key is renamed.|
Clean up database logs
You can delete all or part of the database logs, using the following options:
- Select all logs for a particular table.
- Select specific types of database log.
- Select a date and time that a log was created.
To set up database log cleanup, follow these steps:
Go to System administration > Links > Database > Database log. Select Clean up log.
Under the Records to include header, select Filter.
Choose the method that will be used to select logs to delete. Enter one of the following options:
- Table ID
- Type of log
- Created date and time
Use the Database log cleanup tab to determine when to run the log cleanup task. By default, database logs are available for 30 days.