github_organization.md

title	description
Steampipe Table: github_organization - Query GitHub Organizations using SQL	Allows users to query GitHub Organizations, specifically details about each organization's profile, including name, email, blog, location, and public repository count.

Table: github_organization - Query GitHub Organizations using SQL

GitHub Organizations is a feature within GitHub that allows users to collaborate across many projects at once. Organizations include features such as unified billing, access control, and multiple repositories. It is a way for businesses and open-source projects to manage their projects and teams.

Table Usage Guide

The github_organization table provides insights into Organizations within GitHub. As a developer or project manager, explore organization-specific details through this table, including profile information, public repository count, and associated metadata. Utilize it to uncover information about organizations, such as their location, public repository count, and other profile details.

Important Notes

• You must specify the login column in where or join clause to query the table.
• To list organizations that you are a member of, use the github_my_organization table.

Examples

Basic info for a GitHub Organization

Explore essential details about a specific GitHub organization to understand its structure and activity. This is useful for gaining insights into the organization's verification status, team and member counts, and repository count.

select
  login as organization,
  name,
  twitter_username,
  created_at,
  updated_at,
  is_verified,
  teams_total_count as teams_count,
  members_with_role_total_count as member_count,
  repositories_total_count as repo_count
from
  github_organization
where
  login = 'postgres';

select
  login as organization,
  name,
  twitter_username,
  created_at,
  updated_at,
  is_verified,
  teams_total_count as teams_count,
  members_with_role_total_count as member_count,
  repositories_total_count as repo_count
from
  github_organization
where
  login = 'postgres';

List members of an organization

This query is used to identify members of a specific organization and check if they have two-factor authentication enabled. This can be useful for organizations looking to enforce security measures and ensure all members have additional protection for their accounts.

select
  o.login as organization,
  m.login as user_login,
  m.has_two_factor_enabled as mfa_enabled
from
  github_organization o,
  github_organization_member m
where
  o.login = 'turbot'
and
  o.login = m.organization;

select
  o.login as organization,
  m.login as user_login,
  m.has_two_factor_enabled as mfa_enabled
from
  github_organization o
join
  github_organization_member m on o.login = m.organization
where
  o.login = 'turbot';

OR

select
  organization,
  login as user_login,
  has_two_factor_enabled as mfa_enabled
from
  github_organization_member
where
  organization = 'turbot';

select
  organization,
  login as user_login,
  has_two_factor_enabled as mfa_enabled
from
  github_organization_member
where
  organization = 'turbot';