Control: RDS for MariaDB DB instances should publish logs to CloudWatch Logs
Description
This control checks whether an Amazon RDS for MariaDB DB instance is configured to publish certain types of logs to Amazon CloudWatch Logs. The control fails if the MariaDB DB instance isn't configured to publish the logs to CloudWatch Logs. You can optionally specify which types of logs a MariaDB DB instance should be configured to publish.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.rds_db_instance_mariadb_logging_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.rds_db_instance_mariadb_logging_enabled --share
SQL
This control uses a named query:
select arn as resource, case when engine <> 'mariadb' then 'skip' when enabled_cloudwatch_logs_exports ?& array ['audit','error','general','slowquery'] then 'ok' else 'alarm' end as status, case when engine <> 'mariadb' then title || ' is of ' || engine || ' type.' when enabled_cloudwatch_logs_exports ?& array ['audit','error','general','slowquery'] then title || ' logging enabled.' else title || ' logging disabled.' end as reason , region, account_idfrom aws_rds_db_instance;