turbot/steampipe-mod-terraform-aws-compliance

Control: RDS MySQL DB clusters should have audit logging enabled

Description

This control checks whether Relational Database Service MySQL DB clusters have audit logging enabled.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.rds_mysql_db_cluster_audit_logging_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_aws_compliance.control.rds_mysql_db_cluster_audit_logging_enabled --share

SQL

This control uses a named query:

select
address as resource,
case
when (attributes_std ->> 'engine')::text not like '%mysql' then 'skip'
when (attributes_std ->> 'engine')::text like '%mysql' and (attributes_std -> 'enabled_cloudwatch_logs_exports') @> '["audit"]' then 'ok'
else 'alarm'
end status,
split_part(address, '.', 2) || case
when (attributes_std ->> 'engine')::text not like '%mysql' then ' not a MySQL cluster'
when (attributes_std ->> 'engine')::text like '%mysql' and (attributes_std -> 'enabled_cloudwatch_logs_exports') @> '["audit"]' then ' audit logging enabled'
else ' audit logging disabled'
end || '.' reason
, path || ':' || start_line
from
terraform_resource
where
type = 'aws_rds_cluster';

Tags