Query: cloudfront_distribution_sni

select
  'SNI' as label,
  case when viewer_certificate ->> 'SSLSupportMethod' <> 'sni-only' then 'Disabled' else 'Enabled' end as value,
  case when viewer_certificate ->> 'SSLSupportMethod' <> 'sni-only' then 'alert' else 'ok' end as type
from
  aws_cloudfront_distribution
where
  arn = $1
  and account_id = split_part($1,':',5);