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. 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