Manage Azure SQL Database Auditing using APIs

Applies to: Azure SQL Database

This article provides an overview of the different APIs for managing auditing for Azure SQL Database.

Use Azure PowerShell

PowerShell cmdlets (including WHERE clause support for additional filtering):

• Create or Update Database Auditing Policy (Set-AzSqlDatabaseAudit)
• Create or Update Server Auditing Policy (Set-AzSqlServerAudit)
• Get Database Auditing Policy (Get-AzSqlDatabaseAudit)
• Get Server Auditing Policy (Get-AzSqlServerAudit)
• Remove Database Auditing Policy (Remove-AzSqlDatabaseAudit)
• Remove Server Auditing Policy (Remove-AzSqlServerAudit)
• Create or Update auditing for Microsoft support operations (Set-AzSqlServerMSSupportAudit)

For a script example, see Configure auditing and threat detection using PowerShell.

Use REST API

REST API:

• Create or Update Database Auditing Policy
• Create or Update Server Auditing Policy
• Create or Update Microsoft support operations audit policy
• Get Database Auditing Policy
• Get Server Auditing Policy

Extended policy with WHERE clause support for additional filtering:

• Create or Update Database Extended Auditing Policy
• Create or Update Server Extended Auditing Policy
• Get Database Extended Auditing Policy
• Get Server Extended Auditing Policy

Use Azure CLI

• Manage a server's auditing policy
• Manage a database's auditing policy
• Manage Microsoft support operations audit policy

Use Azure Resource Manager templates

You can manage Azure SQL Database auditing using Azure Resource Manager templates, as shown in these examples:

• Deploy an Azure SQL Database with Auditing enabled to write audit logs to Azure Blob storage account
• Deploy an Azure SQL Database with Auditing enabled to write audit logs to Log Analytics
• Deploy an Azure SQL Database with Auditing enabled to write audit logs to Event Hubs

Auditing in Azure Synapse Analytics

For information about managing auditing by using APIs in Azure Synapse Analytics, see Manage auditing using APIs.

Related content

• Auditing for Azure SQL Database
• What's New in Azure SQL Auditing
• Get started with Azure SQL Managed Instance auditing
• Auditing for SQL Server