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 loginpowerpipe 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_idfrom 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_idfrom aws_rds_db_instance);