last sync: 2023-Dec-04 18:38:36 UTC

Azure Policy definition

Configure Arc-enabled SQL Servers to automatically install Microsoft Defender for SQL and DCR with a Log Analytics workspace

Source Azure Portal
Display name Configure Arc-enabled SQL Servers to automatically install Microsoft Defender for SQL and DCR with a Log Analytics workspace
Id da0fd392-9669-4ad4-b32c-ca46aaa6c21f
Version 1.2.2
Details on versioning
Category Security Center
Microsoft Learn
Description Microsoft Defender for SQL collects events from the agent and uses them to provide security alerts and tailored hardening tasks (recommendations). Create a resource group, a Data Collection Rule and Log Analytics workspace in the same region as the machine.
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
Contributor b24988ac-6180-42a0-ab88-20f7382dd24c
User Access Administrator 18d7d88d-d35e-4fb5-a5c3-7773c20a72d9
Rule aliases IF (2)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.HybridCompute/machines/mssqlDiscovered Microsoft.HybridCompute machines properties.mssqlDiscovered false
Microsoft.HybridCompute/machines/osName Microsoft.HybridCompute machines properties.osName false
Rule resource types IF (1)
Microsoft.HybridCompute/machines
THEN-Deployment (4)
Microsoft.Insights/dataCollectionRules
Microsoft.OperationalInsights/workspaces
Microsoft.Resources/deployments
Microsoft.Resources/resourceGroups
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
Configure SQL VMs and Arc-enabled SQL Servers to install Microsoft Defender for SQL and AMA with a LA workspace d7c3ea3a-edf3-4bd5-bd64-d5b635b05393 Security Center GA BuiltIn
History
Date/Time (UTC ymd) (i) Change type Change detail
2023-11-17 19:29:28 change Patch, old suffix: preview (1.2.1-preview > 1.2.2)
2023-10-31 19:02:40 change Minor, suffix remains equal (1.1.1-preview > 1.2.1-preview)
2023-09-11 17:59:12 change Patch, suffix remains equal (1.1.0-preview > 1.1.1-preview)
2023-08-22 17:59:24 add da0fd392-9669-4ad4-b32c-ca46aaa6c21f
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC