Control: 1.1.1.1.6 Ensure passcode cannot contain consecutive characters is set to enabled (Manual)

powerpipe control run zoom_compliance.control.cis_v100_1_1_1_1_6

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

select
  -- Required Columns
  account_id as resource,
  case
    when (meeting_security -> 'meeting_password_requirement' -> 'consecutive_characters_length')::int > 0 then 'ok'
    else 'alarm'
  end as status,
  'Consecutive characters length set to ' || (security -> 'password_requirement' ->> 'consecutive_characters_length') || '.' as reason
from
  zoom_account_settings