turbot/alicloud_compliance

Query: rds_instance_postgresql_log_duration_parameter_on

Usage

steampipe query alicloud_compliance.query.rds_instance_postgresql_log_duration_parameter_on

Plugins & Tables

SQL

select
-- Required Columns
arn as resource,
case
when engine != 'PostgreSQL' then 'skip'
when parameters -> 'RunningParameters' -> 'DBInstanceParameter' @> '[{"ParameterName": "log_duration", "ParameterValue": "on"}]' then 'ok'
else 'alarm'
end as status,
case
when engine != 'PostgreSQL' then title || ' is ' || engine || ' server.'
when parameters -> 'RunningParameters' -> 'DBInstanceParameter' @> '[{"ParameterName": "log_duration", "ParameterValue": "on"}]' then title || ' ''log_duration'' parameter set to ''on''.'
else title || ' ''log_duration'' parameter set to ''off''.'
end as reason,
-- Additional Dimensions
region,
account_id
from
alicloud_rds_instance;

Controls

The query is being used by the following controls: