turbot/terraform_azure_compliance

GitHub
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:

steampipe check terraform_azure_compliance.control.sql_server_auditing_storage_account_destination_retention_90_days

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share terraform_azure_compliance.control.sql_server_auditing_storage_account_destination_retention_90_days

SQL

This control uses a named query:

sql_server_auditing_storage_account_destination_retention_90_days

Tags