AzPolicyAdvertizer

last sync: 2025-Oct-31 18:22:59 UTC

Configure Azure SQL database servers diagnostic settings to Log Analytics workspace

Azure BuiltIn Policy definition

Source Azure Portal
Display name Configure Azure SQL database servers diagnostic settings to Log Analytics workspace
Id 7ea8a143-05e3-4553-abfe-f56bef8b0b70
Version 1.0.2
Details on versioning
Versioning Versions supported for Versioning: 1
1.0.2
Built-in Versioning [Preview]
Category SQL
Microsoft Learn
Description Enables auditing logs for Azure SQL Database server and stream the logs to a Log Analytics workspace when any SQL Server which is missing this auditing is created or updated
Cloud environments AzureCloud = true
AzureUSGovernment = true
AzureChinaCloud = unknown
Available in AzUSGov The Policy is available in AzureUSGovernment cloud. Version: '1.*.*'
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
SQL Security Manager 056cd41c-7e88-42e1-933e-88ba6a50c9c3
Log Analytics Contributor 92aaf0da-9dab-42b6-94a3-d43ce8d16293
Rule aliases THEN-ExistenceCondition (1)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/auditingSettings.state Microsoft.Sql
Microsoft.Sql		 servers/databases/auditingSettings
servers/auditingSettings		 properties.state
properties.state		 True
True
False
False
Rule resource types IF (1)
THEN-Deployment (1)
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type polSet in AzUSGov
[Preview]: Control the use of diagnostic settings for specific resources in a Virtual Enclave 0a9ea1cb-7925-47fc-b0fe-8bb0a8190423 VirtualEnclaves Preview BuiltIn true
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-04-27 15:38:15 change Patch (1.0.1 > 1.0.2)
2021-02-10 14:43:58 add 7ea8a143-05e3-4553-abfe-f56bef8b0b70
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC