Applies to Product - Dynamics 365 Finance
What’s happening?
The customer is unable to integrate database logs from their system to Application Insights, and the logs for all enabled tables are not visible.
Reason:
Application Insights is not designed to track database logs, and there is no direct integration available for database logs with Application Insights.
Resolution:
- The customer can refer to the article "Configure database logging - Finance & Operations | Dynamics 365 | Microsoft Learn" to understand how to enable database logging.
- Refer to TechTalk Recording [Jan 2025 Monitoring in Microsoft D365 using Application Insights]https://community.dynamics.com/blogs/post/?postid=a907fe5b-b1dd-ef11-a730-7c1e527f02d6
- For further assistance, the customer may consider gaining access to the database to run SQL queries to retrieve the required log data and integrate it with their external systems, such as SPLUNK. However, it is important to note that direct access to UAT and production databases is generally not allowed by Microsoft. Customer can get jit access to Sandbox environments following the steps in the below article. So database can be refreshed from prod to sandbox and jit access can be enabled for sandbox
- The customer can enable just-in-time (JIT) access to their environments by following the steps outlined in the article "Enable just-in-time database access - Finance & Operations | Dynamics 365 | Microsoft Learn."