This SQL View includes details for all licenses in the system.
Back to Reporting SQL Views.
| Field Name | DB Type | Type | Nullable | Description |
|---|---|---|---|---|
| LicenseId | uniqueidentifier | Guid | 0 | ID of the License |
| UserId | uniqueidentifier | Guid | 1 | ID of the user this license is assigned to |
| LicenseOwnerId | uniqueidentifier | Guid | 0 | ID of the user who is owner of this license. i.e. the user who can assign or revoke this license |
| ProductName | nvarchar | String | 0 | Name of the CRM product to which the license belongs to. For example, Studio Developer,Standard User,Studio Runner etc |
| ProductId | uniqueidentifier | Guid | 0 | ID of product type to which the license belongs to |
| LicenseTypeName | nvarchar | String | 0 | Name of license type to which the license belongs to. For example, Perpetual,Subscription etc |
| LicenseTypeId | uniqueidentifier | Guid | 0 | ID of license type to which the license belongs to. For example, Perpetual,Subscription etc |
| OwnerUserName | nvarchar | String | 0 | Name of the user who is owner of this license. Ie. Who can assign or revoke this license |
| AssigneName | nvarchar | String | 0 | Name of the user this license is assigned to |
| StartDate | datetime | DateTime | 0 | Date from which this license can be used |
| ExpiryDate | datetime | DateTime | 1 | The date on which the license expires |
| MaintenanceExpDate | datetime | DateTime | 0 | The date on which the license maintenance expires |
| AllowedMoves | bigint | Int64 | 0 | The nukmber of moves allwed for the license |
| CRMLicenseId | nvarchar | String | 0 | ID for the license that maps to the CRM system (Winshuttle connect site). |
| Module | nvarchar | String | 0 | Name of module to which the license belongs. For example,Transaction | BAPI | Query |
| TenantId | uniqueidentifier | Guid | 0 | ID of the tenant to which the license belongs |
| ModifiedDate | datetime | DateTime | 0 | Date on which the license details were last modified |
| IsAssigned | bit | Boolean | 0 | Indicates if the license is assigned to a user or not |