License Details View

This SQL View includes details for all licenses in the system.


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. For example, 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.
ProductId	uniqueidentifier	Guid	0	ID of product type to which the license belongs.
LicenseTypeName	nvarchar	String	0	Name of license type to which the license belongs to. For example, Perpetual or Subscription.
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. For example, who can assign or revoke this license.
AssigneName	nvarchar	String	0	Name of the user this license is assigned to.
StartDate	datetime	DateTime	0	The 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 number of moves allowed 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.