steampipe plugin install github

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;

Schema for github_organization_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
any_pinnable_itemsbooleanIf true, user has pinnable items.
avatar_urltextThe URL of the user's avatar.
biotextThe biography of the user.
can_changed_pinned_itemsbooleanIf true, you can change the pinned items for this user.
can_create_projectsbooleanIf true, you can create projects for this user.
can_followbooleanIf true, you can follow this user.
can_sponsorbooleanIf true, you can sponsor this user.
companytextThe company on the users profile.
created_attimestamp with time zoneTimestamp when user was created.
emailtextThe email of the user.
estimated_next_sponsors_payout_in_centsbigintThe estimated next GitHub sponsors payout for this user in cents (USD).
has_sponsors_listingbooleanIf true, user has a GitHub sponsors listing.
has_two_factor_enabledbooleanWhether the organization member has two factor enabled or not. Returns null if information is not available to viewer.
idbigintThe ID of the user.
interaction_abilityjsonbThe interaction ability settings for this user.
is_bounty_hunterbooleanIf true, user is a participant in the GitHub security bug bounty.
is_campus_expertbooleanIf true, user is a participant in the GitHub campus experts program.
is_developer_program_memberbooleanIf true, user is a GitHub developer program member.
is_employeebooleanIf true, user is a GitHub employee.
is_followingbooleanIf true, you are following this user.
is_following_youbooleanIf true, user follows you.
is_github_starbooleanIf true, user is a member of the GitHub Stars Program.
is_hireablebooleanIf true, user has marked themselves as for hire.
is_site_adminbooleanIf true, user is a site administrator.
is_sponsoringbooleanIf true, you are sponsoring this user.
is_sponsoring_youbooleanIf true, this user is sponsoring you.
is_youbooleanIf true, user is you.
locationtextThe location of the user.
logintextThe login name of the user.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
monthly_estimated_sponsors_income_in_centsbigintThe estimated monthly GitHub sponsors income for this user in cents (USD).
nametextThe name of the user.
node_idtextThe node ID of the user.
organizationtext=The organization the member is associated with.
pinned_items_remainingbigintHow many more items this user can pin to their profile.
projects_urltextThe URL listing user's projects.
pronounstextThe user's pronouns.
roletextThe role this user has in the organization. Returns null if information is not available to viewer.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sponsors_listingjsonbThe GitHub sponsors listing for this user.
statusjsonbThe user's status.
twitter_usernametextTwitter username of the user.
updated_attimestamp with time zoneTimestamp when user was last updated.
urltextThe URL of the user's GitHub page.
website_urltextThe 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