last sync: 2022-May-24 16:30:29 UTC

Azure Policy definition

SQL servers with auditing to storage account destination should be configured with 90 days retention or higher

Name SQL servers with auditing to storage account destination should be configured with 90 days retention or higher
Azure Portal
Id 89099bee-89e0-4b26-a5f4-165451757743
Version 3.0.0
details on versioning
Category SQL
Microsoft docs
Description For incident investigation purposes, we recommend setting the data retention for your SQL Server' auditing to storage account destination to at least 90 days. Confirm that you are meeting the necessary retention rules for the regions in which you are operating. This is sometimes required for compliance with regulatory standards.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
Rule Aliases THEN-ExistenceCondition (3)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Sql/servers/auditingSettings/isAzureMonitorTargetEnabled Microsoft.Sql servers/auditingSettings properties.isAzureMonitorTargetEnabled false
Microsoft.Sql/servers/auditingSettings/retentionDays Microsoft.Sql servers/auditingSettings properties.retentionDays true
Microsoft.Sql/servers/auditingSettings/storageEndpoint Microsoft.Sql servers/auditingSettings properties.storageEndpoint false
Rule ResourceTypes IF (1)
Microsoft.Sql/servers
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-03-24 14:32:48 change Major (2.1.0 > 3.0.0)
2021-03-09 14:37:41 change Minor (2.0.1 > 2.1.0)
2021-02-10 14:43:58 change Patch (2.0.0 > 2.0.1) *changes on text case sensitivity are not tracked
2020-12-11 15:42:52 change Major (1.0.0 > 2.0.0)
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State Type
[Deprecated]: Azure Security Benchmark v1 42a694ed-f65e-42b2-aa9e-8052e9740a92 Regulatory Compliance Deprecated BuiltIn
[Preview]: Motion Picture Association of America (MPAA) 92646f03-e39d-47a9-9e24-58d60ef49af8 Regulatory Compliance Preview BuiltIn
[Preview]: SWIFT CSCF v2021 abf84fac-f817-a70c-14b5-47eec767458a Regulatory Compliance Preview BuiltIn
Azure Security Benchmark 1f3afdf9-d0c9-4c3d-847f-89da613e70a8 Security Center GA BuiltIn
CIS Microsoft Azure Foundations Benchmark v1.1.0 1a5bb27d-173f-493e-9568-eb56638dde4d Regulatory Compliance GA BuiltIn
CIS Microsoft Azure Foundations Benchmark v1.3.0 612b5213-9160-4969-8578-1518bd2a000c Regulatory Compliance GA BuiltIn
FedRAMP High d5264498-16f4-418a-b659-fa7ef418175f Regulatory Compliance GA BuiltIn
FedRAMP Moderate e95f5a9f-57ad-4d03-bb0b-b1d16db93693 Regulatory Compliance GA BuiltIn
NIST SP 800-171 Rev. 2 03055927-78bd-4236-86c0-f36125a10dc9 Regulatory Compliance GA BuiltIn
NIST SP 800-53 Rev. 4 cf25b9c1-bd23-4eb6-bd2c-f4f3ac644a5f Regulatory Compliance GA BuiltIn
NIST SP 800-53 Rev. 5 179d1daa-458f-4e47-8086-2a68d0d6c38f Regulatory Compliance GA BuiltIn
JSON Changes

JSON