turbot/aws_insights

Query: ecr_repository_scan_on_push_disabled_count

Usage

powerpipe query aws_insights.query.ecr_repository_scan_on_push_disabled_count

Steampipe Tables

SQL

select
count(*) as value,
'Scan on Push Disabled' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as "type"
from
aws_ecr_repository
where
not (image_scanning_configuration ->> 'ScanOnPush') :: bool;

Dashboards

The query is used in the dashboards: