| title | description | author | ms.author | ms.reviewer | ms.date | ms.topic |
|---|---|---|---|---|---|---|
Use activity logs |
Learn how to view or download activity logs for Azure Arc-enabled SQL Server instances or databases. |
guptasnigdha12 |
guptasnigdha |
mikeray, rajpo, randolphwest |
09/09/2024 |
conceptual |
[!INCLUDE sqlserver]
Activity logs for [!INCLUDE ssazurearc] provide insight into events related to SQL Server enabled by Azure Arc and View Azure Arc-enabled inventory resources. Activity logs contain events that correspond to the creation and modification of resources. These events include SQL Server instance updates (SqlServerInstance_Update), SQL Server database updates (SqlServerDatabases_Update), and writing of tags to resources.
This feature helps in auditing operations performed on a resource. The logs provide crucial information such as the time when an operation started, the operation's status, and the party responsible for event creation.
You can access an activity log from most menus in the Azure portal. Go to the Azure Arc-enabled SQL Server resource, and then select Activity log.
The initial filter depends on the page where you access the activity log. You can change the filter to view all other entries. To add more properties to the filter, select Add Filter.
:::image type="content" source="media/monitoring/activity-logs-filter.png" alt-text="Screenshot of an Azure Arc-enabled SQL Server activity log and the button for adding a filter." lightbox="media/monitoring/activity-logs-filter.png":::
To download the events in the current view, select Download as CSV.
:::image type="content" source="media/monitoring/download-as-csv.png" alt-text="Screenshot of the button for downloading events as a CSV file." lightbox="media/monitoring/download-as-csv.png":::
For some events, you can view the history of changes that happened during the event time. Select an event from the activity log to gather more information. Then select Change history to view any changes associated with that event.
:::image type="content" source="media/monitoring/view-change-history.png" alt-text="Screenshot of the change history for an event." lightbox="media/monitoring/view-change-history.png":::