Control: 3.1.1.1.2 Ensure password have at least 1 special character is set to enabled (Manual)

powerpipe control run zoom_compliance.control.cis_v100_3_1_1_1_2

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

select
  -- Required Columns
  account_id as resource,
  case
    when (security -> 'password_requirement' -> 'have_special_character')::bool then 'ok'
    else 'alarm'
  end as status,
  'Have at least 1 special character setting is ' || case when (security -> 'password_requirement' -> 'have_special_character')::bool then 'enabled' else 'disabled' end || '.' as reason
from
  zoom_account_settings