turbot/steampipe-mod-aws-compliance

Control: 1 CloudFormation stacks should be integrated with Simple Notification Service (SNS)

Description

This control checks whether an Amazon Simple Notification Service notification is integrated with a CloudFormation stack. The control fails for a CloudFormation stack if there is no SNS notification associated with it.

Configuring an SNS notification with your CloudFormation stack helps immediately notify stakeholders of any events or changes occurring with the stack.

Remediation

For information about how to update a CloudFormation stack, see AWS CloudFormation stack updates in the AWS CloudFormation User Guide.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.foundational_security_cloudformation_1

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.foundational_security_cloudformation_1 --share

SQL

This control uses a named query:

select
id as resource,
case
when jsonb_array_length(notification_arns) > 0 then 'ok'
else 'alarm'
end as status,
case
when jsonb_array_length(notification_arns) > 0 then title || ' notifications enabled.'
else title || ' notifications disabled.'
end as reason
, region, account_id
from
aws_cloudformation_stack;

Tags