Does Log Analytics collect table modification(Azure SQL DB) logs?

Partha Das 286 Reputation points
2022-11-25T14:22:31.573+00:00

Hi,

Does Log Analytics collect table modification(Azure SQL DB) logs?

Lets take an example - I have a table in Azure SQL DB with diagnostic settings on. I ran simple update statement or changed any cell using SSMS.

Can these actions be logged? If yes, how can I check in Log Analytics workspace?

Please help.

Regards,
Partha

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,034 questions
Azure SQL Database
{count} votes

Accepted answer
  1. TP 83,961 Reputation points
    2022-11-25T16:55:58.197+00:00

    Hi,

    Table/row/cell level changes are not logged using the built-in Azure SQL Database telemetry.

    If you want data changes to be logged to Log Analytics you would need to write your own custom solution. For example, enable Change Data Capture, then write a custom app that sends changes to Log Analytics workspace.

    Configure streaming export of Azure SQL Database and SQL Managed Instance diagnostic telemetry

    https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure

    -TP


1 additional answer

Sort by: Most helpful
  1. Andrew Blumhardt 9,771 Reputation points Microsoft Employee
    2022-11-25T15:21:46.863+00:00

    Most resources in Azure can send logs as diagnostics and metrics to a workspace. Changes to Azure resources can be found in the Azure Activity log. I would think you should see updates in the standard or activity logs.

    https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/activity-log