EnterpriseAdmins
Catalogs the administrators responsible for managing and maintaining a GitHub Enterprise account.
Table-Specific Information
Select
The add-in 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 '=' comparison operator.
- OrganizationLogins supports the '=,IN' comparison operators.
- TwoFactorMethodSecurity supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [EnterpriseAdmins]
SELECT * FROM [EnterpriseAdmins] WHERE [EnterpriseSlug] = 'Val1'
SELECT * FROM [EnterpriseAdmins] WHERE [Role] = 'OWNER'
SELECT * FROM [EnterpriseAdmins] WHERE [OrganizationLogins] = 'Val1'
SELECT * FROM [EnterpriseAdmins] WHERE [TwoFactorMethodSecurity] = 'SECURE'
The add-in processes other filters client-side within the add-in.
The add-in uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Login
- CreatedAt
SELECT * FROM [EnterpriseAdmins] ORDER BY [Login]
SELECT * FROM [EnterpriseAdmins] ORDER BY [CreatedAt]
The add-in uses client-side processing when ordering by any other columns. This impacts performance.
Delete
You can specify the following columns to delete a record:
- Login
- EnterpriseId
DELETE FROM [EnterpriseAdmins] WHERE ([Login] = 'Test') 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 of 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 user’s Twitter handle as listed on their GitHub profile. | |
| 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, which provides an overview or description of the user. | |
| BioHTML | String | True |
The user’s profile bio formatted in HTML for display purposes. | |
| Company | String | True |
The user’s publicly displayed company or organization affiliation. | |
| 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. Accepts arguments to filter by 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 an employee of GitHub. | |
| IsHireable | Bool | True |
Indicates whether the user has marked themselves as available for hire. | |
| 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 this user is following the current viewer of the profile. 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 is financially sponsoring the current viewer of their profile or organization. | |
| IsViewer | Bool | True |
Indicates whether this 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. | |
| ViewerCanCreateProjects | Bool | True |
Indicates whether the current viewer has permission to create new projects for this user or organization. | |
| ViewerCanChangePinnedItems | Bool | True |
Indicates whether the current viewer can pin repositories and gists to the user's profile. | |
| StatusId | String | True |
The unique identifier of the user’s status emoji. | |
| StatusEmoji | String | True |
An emoji representing the user’s current status. | |
| StatusMessage | String | True |
A short, user-defined message describing their current activity or status. | |
| StatusIndicatesLimitedAvailability | Bool | True |
Indicates whether the user’s status suggests they have limited availability on GitHub. | |
| StatusEmojiHTML | String | True |
The HTML representation of the user’s 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 |
The current interaction restriction level on this user’s account or content (for example, collaborators only). | |
| InteractionAbilityOrigin | String | True |
The source or origin of the currently applied interaction restriction (for example, account settings). | |
| InteractionAbilityExpiresAt | Datetime | True |
The date and time when the current interaction restriction 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) spent by this user or organization to sponsor others on GitHub. 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 personal 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 this object was created, in ISO 8601 format. | |
| UpdatedAt | Datetime | True |
The date and time when this object was last updated, in ISO 8601 format. | |
| RepositoryCount | Int | True |
The total number of repositories owned by the user. | |
| FollowerCount | Int | True |
The total number of users following this user on GitHub. | |
| EnterpriseId [KEY] | String | True |
Enterprises.Id |
The unique node ID of the enterprise associated with this user or data. |
| EnterpriseSlug | String | True |
Enterprises.Slug |
The URL-friendly identifier (slug) for the enterprise, used in APIs and URLs. |
| Role | String | True |
The role assigned to the user within the enterprise (for example, 'admin', 'member'). Can be used for filtering. The allowed values are OWNER, BILLING_MANAGER. | |
| OrganizationLogins | String | True |
Organizations.Login |
Filters results to include only members from the specified organizations, identified by their login names. |
| TwoFactorMethodSecurity | String | True |
Filters results to include only users who have this type of two-factor authentication enabled. Excludes users with accounts only on GitHub Enterprise Server instances. The allowed values are SECURE, INSECURE, DISABLED. |