Enterprises
A list of enterprises that the user belongs to.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The 本製品 processes other filters client-side within the 本製品.
- 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. |