turbot/alicloud_compliance

Query: rds_instance_sql_audit_enabled

Usage

powerpipe query alicloud_compliance.query.rds_instance_sql_audit_enabled

Steampipe Tables

SQL

select
arn as resource,
case
when sql_collector_policy ->> 'SQLCollectorStatus' = 'Enable' then 'ok'
else 'alarm'
end as status,
case
when sql_collector_policy ->> 'SQLCollectorStatus' = 'Enable' then title || ' SQL audit enabled.'
else title || ' SQL audit disabled.'
end as reason,
account_id as account_id,
region as region
from
alicloud_rds_instance;

Controls

The query is being used by the following controls: