Query: ecr_repository_use_image_scanning

select
  address as resource,
  case
    when (
      attributes_std -> 'image_scanning_configuration' ->> 'scan_on_push'
    ) :: boolean then 'ok'
    else 'alarm'
  end as status,
  split_part(address, '.', 2) || case
    when (
      attributes_std -> 'image_scanning_configuration' ->> 'scan_on_push'
    ) :: boolean then ' uses image scanning'
    else ' does not use image scanning'
  end || '.' as reason,
  path || ':' || start_line
from
  terraform_resource
where
  type = 'aws_ecr_repository';