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

Resource Types

This control targets the following resource types:

• Azure > SQL > Server

Primary Policies

The following policies can be used to configure this control:

• 4.01.06 - Ensure that 'Auditing' Retention is 'greater than 90 days'

Category

• CIS > Controls v7 > 06 Maintenance, Monitoring, and Analysis of Audit Logs > 6.04 Ensure Adequate Storage for Logs

In Your Workspace

• Controls by Resource report
• Controls by Control Type report

Developers

Control Type URI

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

Category URI

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

GraphQL

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

query controls(filter: "controlTypeId:'tmod:@turbot/azure-cisv2-0#/control/types/r040106'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-cisv2-0#/control/types/r040106"