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;