Query: DMS replication tasks for the source database should have logging enabled

Description

This control checks whether logging is enabled with the minimum severity level of LOGGER_SEVERITY_DEFAULT for DMS replication tasks SOURCE_CAPTURE and SOURCE_UNLOAD. The control fails if logging isn't enabled for these tasks or if the minimum severity level is less than LOGGER_SEVERITY_DEFAULT.

Query

Tables used in this query:

• aws_dms_replication_task

Controls using this query:

• 8 DMS replication tasks for the source database should have logging enabled
• DMS replication tasks for the source database should have logging enabled

SQL