turbot/github_compliance

Query: org_members_cannot_create_repos

Usage

powerpipe query github_compliance.query.org_members_cannot_create_repos

Steampipe Tables

SQL

select
-- Required Columns
url as resource,
case
when members_can_create_public_repos
or members_can_create_private_repos then 'alarm'
else 'ok'
end as status,
login || ' users ' || case
when (members_can_create_public_repos) :: bool
or (members_can_create_private_repos) :: bool then 'can '
else 'cannot '
end || 'create repositories.' as reason,
-- Additional Dimensions
login
from
github_my_organization;

Controls

The query is being used by the following controls: