Query: dms_endpoint_mongo_db_authentication_enabled

select
  arn as resource,
  case
    when endpoint_type <> 'SOURCE' then 'skip'
    when mongo_db_settings is null then 'skip'
    when (mongo_db_settings ->> 'AuthMechanism') = 'default' then 'alarm'
    else 'ok'
  end as status,
  case
    when endpoint_type <> 'SOURCE' then title || ' endpoint is not of source type.'
    when mongo_db_settings is null then title || ' endpoint is not of mongodb engine type.'
    when (mongo_db_settings ->> 'AuthMechanism') = 'default' then title || ' authentication mechanism disabled.'
    else title || ' ' || (mongo_db_settings ->> 'AuthMechanism') || ' authentication mechanism enabled.'
  end as reason
  
  , region, account_id
from
  aws_dms_endpoint;