Enterprises
A list of enterprises that the user belongs to.
View-Specific Information
Select
The provider uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The provider processes other filters client-side within the provider.
- Slug supports the '=' comparison operator.
- MembershipType supports the '=' comparison operator.
- Login supports the '=' comparison operator.
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Slug] = 'test-enterprise'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[MembershipType] = 'ADMIN'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Login] = 'test'
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The ID of the Enterprise object. | ||
| UserId | String | The ID of the User object. | ||
| Location | String | The location of the enterprise. | ||
| Name | String | The name of the enterprise. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| Announcement | String | The text of the announcement. | ||
| AnnouncementExpiresAt | Datetime | The expiration date of the announcement, if any. | ||
| AnnouncementUserDismissible | Bool | Whether the announcement can be dismissed by the user. | ||
| BillingEmail | String | The enterprise's billing email. | ||
| BillingInfoAllLicensableUsersCount | Int | The number of licenseable users/emails across the enterprise. | ||
| BillingInfoAssetPacks | Int | The number of data packs used by all organizations owned by the enterprise. | ||
| BillingInfoBandwidthQuota | Double | The bandwidth quota in GB for all organizations owned by the enterprise. | ||
| BillingInfoBandwidthUsage | Double | The bandwidth usage in GB for all organizations owned by the enterprise. | ||
| BillingInfoBandwidthUsagePercentage | Int | The bandwidth usage as a percentage of the bandwidth quota. | ||
| BillingInfoStorageQuota | Double | The storage quota in GB for all organizations owned by the enterprise. | ||
| BillingInfoStorageUsage | Double | The storage usage in GB for all organizations owned by the enterprise. | ||
| BillingInfoStorageUsagePercentage | Int | The storage usage as a percentage of the storage quota. | ||
| BillingInfoTotalAvailableLicenses | Int | The number of available licenses across all owned organizations based on the unique number of billable users. | ||
| BillingInfoTotalLicenses | Int | The total number of licenses allocated. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| Description | String | The description of the enterprise. | ||
| DescriptionHTML | String | The description of the enterprise as HTML. | ||
| OwnerInfoOidcProviderId | String | The ID of the OIDCProvider object. | ||
| OwnerInfoOidcProviderTenantId | String | The ID of the tenant this provider is attached to. | ||
| OwnerInfoSamlIdentityProviderId | String | The ID of the EnterpriseIdentityProvider object. | ||
| ResourcePath | String | The HTTP path for this enterprise. | ||
| Slug | String | The URL-friendly identifier for the enterprise. | ||
| Url | String | The HTTP URL for this enterprise. | ||
| ViewerIsAdmin | Bool | Is the current viewer an admin of this enterprise? | ||
| WebsiteUrl | String | The URL of the enterprise website. | ||
| MembershipType | String | Filter enterprises returned based on the user's membership type. | ||
| Login | String | The user's login. |