last sync: 2024-Mar-01 17:50:27 UTC

Configure Arc-enabled SQL Servers to automatically install Microsoft Defender for SQL

Azure BuiltIn Policy definition

Source Azure Portal
Display name Configure Arc-enabled SQL Servers to automatically install Microsoft Defender for SQL
Id 65503269-6a54-4553-8a28-0065a8e6d929
Version 1.2.0
Details on versioning
Category Security Center
Microsoft Learn
Description Configure Windows Arc-enabled SQL Servers to automatically install the Microsoft Defender for SQL agent. Microsoft Defender for SQL collects events from the agent and uses them to provide security alerts and tailored hardening tasks (recommendations).
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
Log Analytics Contributor 92aaf0da-9dab-42b6-94a3-d43ce8d16293
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
THEN-ExistenceCondition (3)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.HybridCompute/machines/extensions/provisioningState Microsoft.HybridCompute machines/extensions properties.provisioningState false
Microsoft.HybridCompute/machines/extensions/publisher Microsoft.HybridCompute machines/extensions properties.publisher false
Microsoft.HybridCompute/machines/extensions/type Microsoft.HybridCompute machines/extensions properties.type false
Rule resource types IF (1)
Microsoft.HybridCompute/machines
THEN-Deployment (1)
Microsoft.HybridCompute/machines/extensions
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
Configure SQL VMs and Arc-enabled SQL Servers to install Microsoft Defender for SQL and AMA with a user-defined LA workspace de01d381-bae9-4670-8870-786f89f49e26 Security Center GA BuiltIn
Configure SQL VMs and Arc-enabled SQL Servers to install Microsoft Defender for SQL and AMA with a user-defined LA workspace Deploy-MDFC-DefenderSQL-AMA Security Center GA ALZ
History
Date/Time (UTC ymd) (i) Change type Change detail
2024-01-12 18:35:06 change Minor (1.1.2 > 1.2.0)
2023-11-17 19:29:28 change Patch, old suffix: preview (1.1.1-preview > 1.1.2)
2023-10-31 19:02:40 change Minor, suffix remains equal (1.0.1-preview > 1.1.1-preview)
2023-09-11 17:59:12 change Patch, suffix remains equal (1.0.0-preview > 1.0.1-preview)
2023-08-22 17:59:24 add 65503269-6a54-4553-8a28-0065a8e6d929
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC