turbot/aws_insights

Query: ecr_repository_public_access

Usage

powerpipe query aws_insights.query.ecr_repository_public_access

Steampipe Tables

SQL

select
'Public Access' as label,
initcap(image_tag_mutability) as value,
case when image_tag_mutability = 'IMMUTABLE' then 'ok' else 'alert' end as type
from
aws_ecr_repository
where
arn = $1
and region = split_part($1, ':', 4)
and account_id = split_part($1, ':', 5);