Query: codebuild_project_logging_status

select
  logging_status,
  count(*)
from
  (
    select
      logs_config -> 'CloudWatchLogs' ->> 'Status',
      logs_config -> 'S3Logs' ->> 'Status',
      case
        when (
          logs_config -> 'CloudWatchLogs' ->> 'Status' = 'ENABLED'
        )
        or (logs_config -> 'S3Logs' ->> 'Status' = 'ENABLED') then 'enabled'
        else 'disabled'
      end logging_status
    from
      aws_codebuild_project
  ) as t
group by
  logging_status
order by
  logging_status desc;