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 loginsteampipe 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