Control: 1.1.4.1.2 Ensure data center regions is set to local countries (Manual)

powerpipe control run zoom_compliance.control.cis_v100_1_1_4_1_2

powerpipe login
powerpipe control run zoom_compliance.control.cis_v100_1_1_4_1_2 --share

select
  account_id as resource,
  case
    when meeting_security -> 'approved_or_denied_countries_or_regions' ->> 'method' = 'approve' then 'ok'
    else 'alarm'
  end as status,
  'Method is ' || coalesce(
    meeting_security -> 'approved_or_denied_countries_or_regions' ->> 'method',
    'not set'
  ) || '.' as reason
from
  zoom_account_settings
union
select
  a.account_id as resource,
  'info' as status,
  cc || ' is set.' as reason
from
  zoom_account_settings as a,
  jsonb_array_elements_text(
    meeting_security -> 'approved_or_denied_countries_or_regions' -> 'approved_list'
  ) as cc