Policy: Azure > SQL > Database > Auditing > Retention Days

Define the number of days to keep in the audit logs in the storage account.

Note: Setting the policy to 0 will set the retention to infinity.

Resource Types

This policy targets the following resource types:

This policy is used with the following primary policy:

Schema Type	`number`
Default	`90`

Category URI

tmod:@turbot/turbot#/control/categories/resourceLogging

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/databaseAuditingRetentionDays"