AzPolicyAdvertizer

last sync: 2024-May-03 17:44:48 UTC

Enable logging by category group for SQL databases (microsoft.sql/servers/databases) to Storage

Azure BuiltIn Policy definition

Source Azure Portal
Display name Enable logging by category group for SQL databases (microsoft.sql/servers/databases) to Storage
Id 8656d368-0643-4374-a63f-ae0ed4da1d9a
Version 1.1.0
Details on versioning
Category Monitoring
Microsoft Learn
Description Resource logs should be enabled to track activities and events that take place on your resources and give you visibility and insights into any changes that occur. This policy deploys a diagnostic setting using a category group to route logs to a Storage Account for SQL databases (microsoft.sql/servers/databases).
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, AuditIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
Log Analytics Contributor 92aaf0da-9dab-42b6-94a3-d43ce8d16293
Rule aliases THEN-ExistenceCondition (4)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Insights/diagnosticSettings/logs[*] microsoft.insights diagnosticSettings properties.logs[*] false
microsoft.insights/diagnosticSettings/logs[*].categoryGroup microsoft.insights diagnosticSettings properties.logs[*].categoryGroup false
Microsoft.Insights/diagnosticSettings/logs[*].enabled microsoft.insights diagnosticSettings properties.logs[*].enabled false
Microsoft.Insights/diagnosticSettings/storageAccountId microsoft.insights diagnosticSettings properties.storageAccountId false
Rule resource types IF (1)
Microsoft.sql/servers/databases
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
Enable audit category group resource logging for supported resources to storage 8d723fb6-6680-45be-9d37-b1a4adb52207 Monitoring GA BuiltIn
History
Date/Time (UTC ymd) (i) Change type Change detail
2024-04-08 17:52:20 change Minor (1.0.0 > 1.1.0)
2023-02-10 18:41:56 add 8656d368-0643-4374-a63f-ae0ed4da1d9a
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC