Query: sns_topic_notification_delivery_status_enabled

select
  topic_arn as resource,
  case
    when application_failure_feedback_role_arn is null
      and firehose_failure_feedback_role_arn is null
      and http_failure_feedback_role_arn is null
      and lambda_failure_feedback_role_arn is null
      and sqs_failure_feedback_role_arn is null then 'alarm'
    else 'ok'
  end as status,
  case
    when application_failure_feedback_role_arn is null
      and firehose_failure_feedback_role_arn is null
      and http_failure_feedback_role_arn is null
      and lambda_failure_feedback_role_arn is null
      and sqs_failure_feedback_role_arn is null then title || ' has delivery status logging for notification messages disabled.'
    else title || ' has delivery status logging for notification messages enabled.'
  end as reason
  
  , region, account_id
from
  aws_sns_topic;