turbot/steampipe-mod-aws-compliance

Control: RDS DB instance and cluster enhanced monitoring should be enabled

Description

Enable AWS Relational Database Service (AWS RDS) to help monitor AWS RDS availability. This provides detailed visibility into the health of your AWS RDS database instances.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.rds_db_instance_and_cluster_enhanced_monitoring_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.rds_db_instance_and_cluster_enhanced_monitoring_enabled --share

SQL

This control uses a named query:

(
select
arn as resource,
case
when enabled_cloudwatch_logs_exports is not null then 'ok'
else 'alarm'
end as status,
case
when enabled_cloudwatch_logs_exports is not null then title || ' enhanced monitoring enabled.'
else title || ' enhanced monitoring not enabled.'
end as reason
, region, account_id
from
aws_rds_db_cluster
)
union
(
select
arn as resource,
case
when class = 'db.m1.small' then 'skip'
when enhanced_monitoring_resource_arn is not null then 'ok'
else 'alarm'
end as status,
case
when class = 'db.m1.small' then title || ' enhanced monitoring not supported.'
when enhanced_monitoring_resource_arn is not null then title || ' enhanced monitoring enabled.'
else title || ' enhanced monitoring not enabled.'
end as reason
, region, account_id
from
aws_rds_db_instance
);

Tags