AzPolicyAdvertizer

last sync: 2024-Nov-25 18:54:24 UTC

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

Azure BuiltIn Policy definition

Source Azure Portal
Display name Enable logging by category group for SQL databases (microsoft.sql/servers/databases) to Log Analytics
Id 6567d3f3-42d0-4cfb-9606-9741ba60fa07
Version 1.1.0
Details on versioning
Versioning Versions supported for Versioning: 2
1.0.0
1.1.0
Built-in Versioning [Preview]
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 Log Analytics workspace 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 Path PathIsDefault DefaultPath Modifiable
Microsoft.Insights/diagnosticSettings/logs[*] microsoft.insights diagnosticSettings properties.logs[*] True False
microsoft.insights/diagnosticSettings/logs[*].categoryGroup microsoft.insights diagnosticSettings properties.logs[*].categoryGroup True False
Microsoft.Insights/diagnosticSettings/logs[*].enabled microsoft.insights diagnosticSettings properties.logs[*].enabled True False
Microsoft.Insights/diagnosticSettings/workspaceId microsoft.insights diagnosticSettings properties.workspaceId True 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 allLogs category group resource logging for supported resources to Log Analytics 0884adba-2312-4468-abeb-5422caed1038 Monitoring GA BuiltIn
Enable audit category group resource logging for supported resources to Log Analytics f5b29bc4-feca-4cc6-a58a-772dd5e290a5 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 6567d3f3-42d0-4cfb-9606-9741ba60fa07
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC