BeyondERP.Newsletter
Menu

Setup step on the Database log setup page · System administration

Set up Database log setup

Use this page to keep an auditable record of changes to tables that hold sensitive information.

Used by
Information technology manager
Business process
Administer system features
Menu item
SysDatabaseLogSetup
Main table
DatabaseLog
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you choose which tables and fields are logged, and for which changes, such as insert, update, delete and rename key.
What you do hereUse this page to keep an auditable record of changes to tables that hold sensitive information.
ExampleFor example, you can track changes to the vendor bank account number or the customer credit limit.
Database log setup page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Setup › Database log › Database log setup
Set up firstDatabase log parameters Microsoft Learn
Used next byDatabase Log Microsoft Learn Database log cleanup Microsoft Learn
Related pagesElectronic signature requirements Microsoft Learn
In this process Set up Period templates · Set up Working time templates
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Database log setup1 screen

Use this page to keep an auditable record of changes to tables that hold sensitive information.

  1. Screen 1

    Review the database log setup

    Go to System administration > Setup > Database log > Database log setup

    1. Review which tables are logged and for which type of change
    2. Select New to open the Logging database changes wizard
    3. Choose the tables or fields to log and the types of change
    4. Select Finish to complete the wizard
    Review the database log setup (zoomed on the outlined fields)
    Show the full screenReview the database log setup
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Database log > Database log setup.
  2. Select New to open the Logging database changes wizard.
  3. Choose the tables or fields to log and the types of change.
  4. Select Finish to complete the wizard.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Consistency checkRe-creates missing log triggers and removes orphaned ones; it also runs when you finish the wizard.Microsoft Learn

Common errors and fixes

MessageWhat to do
Changes aren't logged although the table is set upSelect Consistency check on Database log setup: it re-creates missing log triggers and drops orphaned ones. Microsoft Learn
The Database Log report doesn't show all entriesThe Database Log report displays up to 10,000 records; filter by table, type or date. Microsoft Learn

Test checklist

  1. Select New and use the Logging database changes wizard to log updates to one field.
  2. Change that field on a record.
  3. Open System administration > Inquiries > Database > Database log and check the entry.
  4. Select Consistency check and schedule Clean up log per company.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Database log setupLog specific fields on tables that hold sensitive data rather than whole tables, with a plan for how long logs are kept and a cleanup job per companyLearn recommends logging specific fields to limit log entries and improve performance, and planning retention and cleanup because the log table grows quickly.What should be logged?Logging busy tables: logging turns set-based operations into row-based ones and can slow long processes such as inventory close, BOM calculation, master planning and data imports.Test: Field change is logged

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. By default the system logs all transactions that use electronic signatures. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyYou choose tables and fields for the whole environment database; the log entries it writes are cleaned up per company, because an administrator must set up a cleanup job per company. Microsoft Learn
Can it be undoneReversible: Logging can be changed at any time. Log cleanup deletes log records, except records that are electronically signed.
If you change it laterLogging a table turns its set-based operations into row-based ones and makes the log grow, which can slow long-running processes; log specific fields where you can. Microsoft Learn
Technical architect

6Technical

Menu itemSysDatabaseLogSetup Checked in Dynamics 365
FormSysDatabaseLogSetup Checked in Dynamics 365
TableDatabaseLogShown as “Database logs” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain database log setup SysDatabaseLogSetupMaintainDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysDatabaseLogSetup
Data migrationLoad order: Set up logging with the Logging database changes wizard in each environment, then run Consistency check so the log triggers match the setup.Microsoft Learn
Everyone

8Sources

To cite this step: SA-SETUP-280, Set up Database log setup. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-SETUP-280