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;