Query: ecr_repository_scan_on_push_status

select
  push_status,
  count(*)
from (
  select
    (image_scanning_configuration ->> 'ScanOnPush')::bool,
    case when (image_scanning_configuration ->> 'ScanOnPush')::bool then
      'enabled'
    else
      'disabled'
    end push_status
  from
    aws_ecr_repository) as t
group by
  push_status
order by
  push_status desc;