EnterpriseMembers
Lists all users who are members of a specified GitHub Enterprise account.
Table-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- EnterpriseSlug supports the '=,IN' comparison operators.
- Role supports the '=,IN' comparison operators.
- OrganizationLogins supports the '=,IN' comparison operators.
- Deployment supports the '=,IN' comparison operators.
- TwoFactorMethodSecurity supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [EnterpriseMembers]
SELECT * FROM [EnterpriseMembers] WHERE [EnterpriseSlug] = 'Val1'
SELECT * FROM [EnterpriseMembers] WHERE [Role] = 'MEMBER'
SELECT * FROM [EnterpriseMembers] WHERE [OrganizationLogins] = 'Val1'
SELECT * FROM [EnterpriseMembers] WHERE [Deployment] = 'CLOUD'
SELECT * FROM [EnterpriseMembers] WHERE [TwoFactorMethodSecurity] = 'SECURE'
The 本製品 processes other filters client-side within the 本製品.
The 本製品 uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Login
- CreatedAt
SELECT * FROM [EnterpriseMembers] ORDER BY [Login]
SELECT * FROM [EnterpriseMembers] ORDER BY [CreatedAt]
The 本製品 uses client-side processing when ordering by any other columns. This impacts performance.
Delete
You can specify the following columns to delete a record:
- Id
- EnterpriseId
DELETE FROM [EnterpriseMembers] WHERE ([Id] = 'U_kgDOCRzGkQ') AND ([EnterpriseId] = 'E_kgDOAAO82g')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier (node ID) assigned to the user. | |
| DatabaseId | Int | True |
The primary key identifier for the user in the database, used for internal reference. | |
| Login | String | True |
The unique username of the user, used for login and profile identification. | |
| Name | String | True |
The publicly visible name of the user as displayed on their GitHub profile. | |
| String | True |
The publicly visible email address associated with the user’s GitHub profile. | ||
| TwitterUsername | String | True |
The Twitter handle listed on the user’s GitHub profile, if provided. | |
| Pronouns | String | True |
The pronouns specified by the user on their GitHub profile (for example, they/them, she/her, he/him). | |
| Bio | String | True |
The user’s public profile bio, describing their professional background or interests. | |
| BioHTML | String | True |
The HTML-formatted version of the user’s bio for display purposes. | |
| Company | String | True |
The publicly visible company or organization affiliation listed on the user’s profile. | |
| CompanyHTML | String | True |
The HTML-formatted version of the user’s company information for display purposes. | |
| Location | String | True |
The geographic location specified by the user on their public profile. | |
| AnyPinnableItems | Bool | True |
Indicates whether the user has any content, such as repositories or gists, that can be pinned to their profile. Can be filtered by content type. | |
| PinnedItemsRemaining | Int | True |
The number of additional items the user can pin to their profile. | |
| ItemShowcaseHasPinnedItems | Bool | True |
Indicates whether the user has pinned any repositories or gists to their profile. | |
| IsEmployee | Bool | True |
Indicates whether the user is a GitHub employee. | |
| IsHireable | Bool | True |
Indicates whether the user has marked themselves as available for hire on GitHub. | |
| IsBountyHunter | Bool | True |
Indicates whether the user participates in the GitHub Security Bug Bounty program. | |
| IsCampusExpert | Bool | True |
Indicates whether the user is a member of the GitHub Campus Experts program. | |
| IsFollowingViewer | Bool | True |
Indicates whether the user is following the current viewer of their profile. This is the inverse of ViewerIsFollowing. | |
| IsSiteAdmin | Bool | True |
Indicates whether the user is a GitHub site administrator with elevated permissions. | |
| IsDeveloperProgramMember | Bool | True |
Indicates whether the user is a member of the GitHub Developer Program. | |
| IsGitHubStar | Bool | True |
Indicates whether the user is a recognized member of the GitHub Stars program. | |
| IsSponsoringViewer | Bool | True |
Indicates whether the user or organization is financially sponsoring the current viewer. | |
| IsViewer | Bool | True |
Indicates whether the user is the currently logged-in viewer of the profile. | |
| ViewerCanFollow | Bool | True |
Indicates whether the current viewer has the ability to follow this user. | |
| ViewerCanSponsor | Bool | True |
Indicates whether the current viewer can sponsor this user or organization through GitHub Sponsors. | |
| ViewerIsFollowing | Bool | True |
Indicates whether the current viewer is following this user. | |
| ViewerIsSponsoring | Bool | True |
Indicates whether the current viewer is sponsoring this user or organization through GitHub Sponsors. | |
| ViewerCanCreateProjects | Bool | True |
Indicates whether the current viewer can create new projects for this user or organization. | |
| ViewerCanChangePinnedItems | Bool | True |
Indicates whether the current viewer has permission to pin repositories and gists to the user's profile. | |
| StatusId | String | True |
The unique identifier (ID) of the emoji representing the user’s status. | |
| StatusEmoji | String | True |
An emoji that visually summarizes the user’s current status. | |
| StatusMessage | String | True |
A brief, user-defined message that describes what the user is currently doing or their availability. | |
| StatusIndicatesLimitedAvailability | Bool | True |
Indicates whether the user’s status suggests limited availability on GitHub. | |
| StatusEmojiHTML | String | True |
The HTML representation of the status emoji for display purposes. | |
| StatusCreatedAt | Datetime | True |
The date and time when the user’s status was created, in ISO 8601 format. | |
| StatusExpiresAt | Datetime | True |
The expiration date and time for the user’s status. After this time, the status is no longer be visible. | |
| StatusUpdatedAt | Datetime | True |
The date and time when the user’s status was last updated, in ISO 8601 format. | |
| StatusOrganizationId | String | True |
The unique identifier (node ID) of the organization associated with the user’s status. | |
| StatusOrganizationLogin | String | True |
The login name of the organization associated with the user’s status. | |
| InteractionAbilityLimit | String | True |
Specifies the current interaction limit applied to this user’s account or content (for example, collaborators only). | |
| InteractionAbilityOrigin | String | True |
The source or reason for the currently active interaction limit (for example, account settings or an admin action). | |
| InteractionAbilityExpiresAt | Datetime | True |
The date and time when the currently active interaction limit expires, if applicable. | |
| HasSponsorsListing | Bool | True |
Indicates whether this user or organization has an active GitHub Sponsors listing. | |
| MonthlyEstimatedSponsorsIncomeInCents | Int | True |
The estimated monthly income from GitHub Sponsors for this user or organization, in cents (USD). | |
| EstimatedNextSponsorsPayoutInCents | Int | True |
The estimated amount of the next payout from GitHub Sponsors for this user or organization, in cents (USD). | |
| SponsorsListingId | String | True |
The unique identifier (node ID) of the GitHub Sponsors listing for this user or organization. | |
| SponsorsListingName | String | True |
The full display name of the GitHub Sponsors listing for this user or organization. | |
| TotalSponsorshipAmountAsSponsorInCents | Int | True |
The total amount (in cents, USD) that this entity has spent on GitHub to sponsor others. Only visible to the user or managers of the organization. | |
| ResourcePath | String | True |
The relative HTTP path to this user’s profile on GitHub. | |
| ProjectsResourcePath | String | True |
The relative HTTP path to the list of projects associated with this user. | |
| Url | String | True |
The absolute HTTP URL for this user’s GitHub profile. | |
| ProjectsUrl | String | True |
The absolute HTTP URL to the list of projects associated with this user. | |
| WebsiteUrl | String | True |
A URL pointing to the user’s public website or blog, as listed on their profile. | |
| AvatarUrl | String | True |
The URL pointing to the user’s public avatar image. Optionally accepts a 'size' argument to specify the dimensions of the square image in pixels. | |
| CopilotEndpointsApi | String | True |
The API endpoint used to interact with GitHub Copilot services. | |
| CopilotEndpointsOriginTracker | String | True |
The endpoint used by GitHub Copilot for tracking the origin of requests. | |
| CopilotEndpointsProxy | String | True |
The proxy endpoint used for routing GitHub Copilot requests. | |
| CopilotEndpointsTelemetry | String | True |
The telemetry endpoint used for collecting data related to GitHub Copilot activities and usage. | |
| CreatedAt | Datetime | True |
The date and time when the user or object was created, in ISO 8601 format. | |
| UpdatedAt | Datetime | True |
The date and time when the user or object was last updated, in ISO 8601 format. | |
| RepositoryCount | Int | True |
The total number of repositories owned by the user within the enterprise. | |
| FollowerCount | Int | True |
The total number of users following this user within the enterprise. | |
| EnterpriseId [KEY] | String | True |
Enterprises.Id |
The unique node ID of the enterprise associated with the user. |
| EnterpriseSlug | String | True |
Enterprises.Slug |
A URL-friendly identifier (slug) for the enterprise, used in APIs and URLs. |
| Role | String | True |
The specific role assigned to the user within the enterprise (for example, admin, member, or other enterprise-specific roles). 使用できる値は次のとおりです。MEMBER, OWNER, UNAFFILIATED | |
| OrganizationLogins | String | True |
Organizations.Login |
Filters results to include only users who belong to the specified organizations, identified by their login names. |
| Deployment | String | True |
Filters results to include only users associated with the specified GitHub Enterprise deployment. 使用できる値は次のとおりです。CLOUD, SERVER | |
| TwoFactorMethodSecurity | String | True |
Filters results to include only users who have enabled this type of two-factor authentication. Excludes users limited to accounts on GitHub Enterprise Server instances. 使用できる値は次のとおりです。SECURE, INSECURE, DISABLED |