Control: 1.2.6.2 Ensure passcode have at least 1 letter is set to enabled (Manual)

powerpipe control run zoom_compliance.control.cis_v100_1_2_6_2

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

select
  -- Required Columns
  account_id as resource,
  case
    when (
      recording -> 'recording_password_requirement' -> 'have_letter'
    ) :: bool then 'ok'
    else 'alarm'
  end as status,
  'Have at least 1 letter setting is ' || case
    when (
      recording -> 'recording_password_requirement' -> 'have_letter'
    ) :: bool then 'enabled'
    else 'disabled'
  end || '.' as reason
from
  zoom_account_settings