Query: DMS replication tasks for the target 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 TARGET_APPLY and TARGET_LOAD. 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:

• 7 DMS replication tasks for the target database should have logging enabled
• DMS replication tasks for the target database should have logging enabled

SQL