Query: cloudtrail_trail_log_file_validation_status

select
  log_file_validation_status,
  count(*)
from
  (
    select
      case
        when log_file_validation_enabled then 'enabled'
        else 'disabled'
      end log_file_validation_status
    from
      aws_cloudtrail_trail
    where
      region = home_region
  ) as t
group by
  log_file_validation_status
order by
  log_file_validation_status desc