turbot/github_compliance

Query: org_two_factor_required

Usage

powerpipe query github_compliance.query.org_two_factor_required

Steampipe Tables

SQL

select
-- Required Columns
url as resource,
case
when two_factor_requirement_enabled is null then 'info' -- info is only available to owners
when two_factor_requirement_enabled then 'ok'
else 'alarm'
end as status,
coalesce(name, login) || case
when (two_factor_requirement_enabled)::bool is null then ' two-factor authentication unknown, manual verification required'
when (two_factor_requirement_enabled)::bool then ' requires two-factor authentication'
else ' does not require two-factor authentication' end || '.' as reason,
-- Additional Dimensions
login
from
github_my_organization;

Controls

The query is being used by the following controls: