Table: github_organization_member - Query GitHub Organization Members using SQL

GitHub Organization Members is a feature within GitHub that allows you to manage and coordinate teams and repositories within your organization. It provides a centralized way to manage permissions for various repositories, assign roles to members, and monitor the status of each member. GitHub Organization Members helps you maintain control over the resources within your organization and manage member access effectively.

Table Usage Guide

The github_organization_member table provides insights into members within a GitHub organization. As a project manager or team leader, explore member-specific details through this table, including roles, permissions, and status. Utilize it to uncover information about members, such as their roles within the organization, their access permissions, and their activity status.

Important Notes

You must specify the organization column in where or join clause to query the table.

Examples

List organization members

Explore which members belong to your organization and their respective roles, while also identifying if they have two-factor authentication enabled. This can enhance your organization's security by ensuring all members have this additional layer of protection.

select
  organization,
  login,
  role,
  has_two_factor_enabled
from
  github_organization_member
where
  organization = 'my_org';

select
  organization,
  login,
  role,
  has_two_factor_enabled
from
  github_organization_member
where
  organization = 'my_org';

List admin members with two factor authentication disabled

Identify instances where administrative members in your organization have not enabled two-factor authentication, allowing you to enhance your organization's security by addressing these vulnerabilities.

select
  organization,
  login,
  role,
  has_two_factor_enabled
from
  github_organization_member
where
  organization = 'my_org'
  and role = 'ADMIN'
  and not has_two_factor_enabled;

select
  organization,
  login,
  role,
  has_two_factor_enabled
from
  github_organization_member
where
  organization = 'my_org'
  and role = 'ADMIN'
  and not has_two_factor_enabled;

Control examples

Schema for github_organization_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
any_pinnable_items	boolean		If true, user has pinnable items.
avatar_url	text		The URL of the user's avatar.
bio	text		The biography of the user.
can_changed_pinned_items	boolean		If true, you can change the pinned items for this user.
can_create_projects	boolean		If true, you can create projects for this user.
can_follow	boolean		If true, you can follow this user.
can_sponsor	boolean		If true, you can sponsor this user.
company	text		The company on the users profile.
created_at	timestamp with time zone		Timestamp when user was created.
email	text		The email of the user.
estimated_next_sponsors_payout_in_cents	bigint		The estimated next GitHub sponsors payout for this user in cents (USD).
has_sponsors_listing	boolean		If true, user has a GitHub sponsors listing.
has_two_factor_enabled	boolean		Whether the organization member has two factor enabled or not. Returns null if information is not available to viewer.
id	bigint		The ID of the user.
interaction_ability	jsonb		The interaction ability settings for this user.
is_bounty_hunter	boolean		If true, user is a participant in the GitHub security bug bounty.
is_campus_expert	boolean		If true, user is a participant in the GitHub campus experts program.
is_developer_program_member	boolean		If true, user is a GitHub developer program member.
is_employee	boolean		If true, user is a GitHub employee.
is_following	boolean		If true, you are following this user.
is_following_you	boolean		If true, user follows you.
is_github_star	boolean		If true, user is a member of the GitHub Stars Program.
is_hireable	boolean		If true, user has marked themselves as for hire.
is_site_admin	boolean		If true, user is a site administrator.
is_sponsoring	boolean		If true, you are sponsoring this user.
is_sponsoring_you	boolean		If true, this user is sponsoring you.
is_you	boolean		If true, user is you.
location	text		The location of the user.
login	text		The login name of the user.
monthly_estimated_sponsors_income_in_cents	bigint		The estimated monthly GitHub sponsors income for this user in cents (USD).
name	text		The name of the user.
node_id	text		The node ID of the user.
organization	text	=	The organization the member is associated with.
pinned_items_remaining	bigint		How many more items this user can pin to their profile.
projects_url	text		The URL listing user's projects.
pronouns	text		The user's pronouns.
role	text		The role this user has in the organization. Returns null if information is not available to viewer.
sponsors_listing	jsonb		The GitHub sponsors listing for this user.
status	jsonb		The user's status.
twitter_username	text		Twitter username of the user.
updated_at	timestamp with time zone		Timestamp when user was last updated.
url	text		The URL of the user's GitHub page.
website_url	text		The URL pointing to the user's public website/blog.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- github

You can pass the configuration to the command with the --config argument:

steampipe_export_github --config '<your_config>' github_organization_member