turbot/alicloud_compliance

Query: rds_instance_sql_audit_retention_period_180_days

Usage

steampipe query alicloud_compliance.query.rds_instance_sql_audit_retention_period_180_days

Plugins & Tables

SQL

select
-- Required Columns
arn as resource,
case
when sql_collector_retention > 180 then 'ok'
else 'alarm'
end as status,
title || ' SQL audit enabled with retention period ' || sql_collector_retention || ' days.'
as reason,
-- Additional Dimensions
region,
account_id
from
alicloud_rds_instance;