turbot/azure_compliance
Loading controls...

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

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.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.sql_server_auditing_storage_account_destination_retention_90_days

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.sql_server_auditing_storage_account_destination_retention_90_days --share

SQL

This control uses a named query:

sql_server_auditing_storage_account_destination_retention_90_days

Tags