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