Control: 1.1.2.3 Ensure participants video is set to disabled (Manual)

powerpipe control run zoom_compliance.control.cis_v100_1_1_2_3

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

select
  -- Required Columns
  account_id as resource,
  case
    when (schedule_meeting -> 'participants_video') :: bool then 'alarm'
    else 'ok'
  end as status,
  'Participants Video On is ' || case
    when (schedule_meeting -> 'participants_video') :: bool then 'enabled'
    else 'disabled'
  end || '.' as reason
from
  zoom_account_settings
union
select
  -- Required Columns
  account_id as resource,
  case
    when (schedule_meeting -> 'participants_video') :: bool then 'ok'
    else 'alarm'
  end as status,
  'Participants Video On setting is' || case
    when not (schedule_meeting -> 'participants_video') :: bool then ' not'
    else ''
  end || ' locked.' as reason
from
  zoom_account_lock_settings