Control: 3.1.1.1.1 Ensure minimum password length is set to 9 characters or greater (Manual)

powerpipe control run zoom_compliance.control.cis_v100_3_1_1_1_1

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

select
  -- Required Columns
  account_id as resource,
  case
    when (security -> 'password_requirement' -> 'minimum_password_length')::int >= 9 then 'ok'
    else 'alarm'
  end as status,
  'Minimum password length set to ' || (security -> 'password_requirement' ->> 'minimum_password_length') || '.' as reason
from
  zoom_account_settings