turbot/alicloud_compliance

Query: rds_instance_sql_audit_retention_period_180_days

Usage

powerpipe query alicloud_compliance.query.rds_instance_sql_audit_retention_period_180_days

Steampipe Tables

SQL

select
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,
account_id as account_id,
region as region
from
alicloud_rds_instance;

Controls

The query is being used by the following controls: