turbot/aws_compliance

Query: cloudformation_stack_drift_detection_check

Usage

powerpipe query aws_compliance.query.cloudformation_stack_drift_detection_check

Steampipe Tables

SQL

select
id as resource,
case
when stack_drift_status = 'IN_SYNC' then 'ok'
when stack_drift_status = 'DRIFTED' then 'alarm'
else 'skip'
end as status,
case
when stack_drift_status = 'IN_SYNC' then title || ' drift status is ' || stack_drift_status || '.'
when stack_drift_status = 'DRIFTED' then title || ' drift status is ' || stack_drift_status || '.'
else title || ' drift status is ' || stack_drift_status || '.'
end as reason,
region,
account_id
from
aws_cloudformation_stack;

Controls

The query is being used by the following controls: