This SQL View includes the number of licenses in the system.
Back to Reporting SQL Views.
| Field Name | DB Type | Type | Nullable | Description |
|---|---|---|---|---|
| Product | nvarchar | String | 0 | The name of the CRM product to which the user license belongs. For example, Studio Developer, Standard User, or Studio Runner. |
| TotalCount | int | Int32 | 0 | The total number of product licenses. |
| Active | int | Int32 | 0 | The number of active product licenses. |
| Expired | int | Int32 | 0 | The number of expired product licenses. |
| Assigned | int | Int32 | 0 | The number of assigned product licenses. |
| Available | int | Int32 | 0 | The number of available product licenses. |