CompanySubscriptions
Represents a commercial subscription for a tenant.
Table Specific Information
Select
Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition.
For example:
SELECT * from CompanySubscriptions where Id = '4911b631-1b83-4384-9f22-9c8eb03e5c63'
SELECT * FROM CompanySubscriptions WHERE Id IN ('4911b631-1b83-4384-9f22-9c8eb03e5c63')
Columns
| Name | Type | Description |
| id [KEY] | String | The unique identifier for the company subscription. |
| commerceSubscriptionId | String | The ID of this subscription in the commerce system. |
| createdDateTime | Datetime | The date and time when the company subscription was created in Azure Active Directory. |
| isTrial | Bool | Whether the subscription is a free trial or purchased. |
| nextLifecycleDateTime | Datetime | The date and time when the subscription will move to the next state if not renewed by the tenan. |
| ownerId | String | The object ID of the account admin. |
| ownerTenantId | String | The unique identifier for the Microsoft partner tenant that created the subscription on a customer tenant. |
| ownerType | String | Indicates the entity that ownerId belongs to. |
| serviceStatus | String | The provisioning status of each service included in this subscription. |
| skuId | String | The object ID of the SKU associated with this subscription. |
| skuPartNumber | String | The SKU associated with this subscription. |
| status | String | The status of this subscription. |
| totalLicenses | Int | The number of licenses included in this subscription. |