Policy: Azure > CIS v2.0 > 04 - Database Services > 4.01 SQL Server - Auditing > 4.01.06 - Ensure that 'Auditing' Retention is 'greater than 90 days'

Configures auditing against a CIS Benchmark item.

Level: 1

SQL Server Audit Retention should be configured to be greater than 90 days.

Resource Types

This policy targets the following resource types:

This policy is used with the following primary policy:

Schema Type	`string`
Default	`Per Azure > CIS v2.0 > 04 - Database Services`
Valid Values [YAML]	`Per Azure > CIS v2.0 > 04 - Database Services` `Skip` `Check: Benchmark`

Category URI

tmod:@turbot/cis#/control/categories/v070604

Policy Type URI

tmod:@turbot/azure-cisv2-0#/policy/types/r040106

GraphQL

query policyType(id: "tmod:@turbot/azure-cisv2-0#/policy/types/r040106") { … }

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

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

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-cisv2-0#/policy/types/r040106"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-cisv2-0#/policy/types/r040106"