Control: CloudFormation Stacks should have notifications enabled

Description

This control checks whether CloudFormation Stacks are associated with an SNS topic to receive notifications when an event occurs.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.cloudformation_stack_notifications_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std ->> 'notification_arns') is not null then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'notification_arns') is not null then ' notifications enabled'
    else ' notifications disabled'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'aws_cloudformation_stack';

Control: CloudFormation Stacks should have notifications enabled

Description

Usage

SQL

Tags