Control: 1.1.2.1.6 Include both uppercase and lower case letters (Automated)

Usage

Run the control in your terminal:

steampipe check zoom_compliance.control.cis_v100_1_1_2_1_6

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share zoom_compliance.control.cis_v100_1_1_2_1_6

zoom_account_settings

SQL

select
  -- Required Columns
  account_id as resource,
  case
    when (
      schedule_meeting -> 'meeting_password_requirement' -> 'have_upper_and_lower_characters'
    ) :: bool then 'ok'
    else 'alarm'
  end as status,
  'Have uppercase and lowercase characters is ' || case
    when (
      schedule_meeting -> 'meeting_password_requirement' -> 'have_upper_and_lower_characters'
    ) :: bool then 'enabled'
    else 'disabled'
  end || '.' as reason
from
  zoom_account_settings

Tags