ContractUseRight Table

ContractUseRight contains licensing rules most of which can be set by PURL.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ContractUseRight table

Database Column

Details

ContractUseRightID

Type: integer. Key. Generated ID

A unique identifier

ContractID

Type: integer. Key

A unique identifier for a contract.

ReassignmentTimeLimit AppliesDevice

Type: boolean

If 1 then the license cannot be reassigned for some period of time (example is Microsoft 90 day rule)

ReassignmentTimeLimit AppliesUser

Type: boolean

If 1 then the license cannot be reassigned for some period of time (example is Microsoft 90 day rule)

ReassignmentTimeLimit Device

Type: integer. Nullable

The period (in days) within which the license cannot be reassigned

ReassignmentTimeLimitUser

Type: integer. Nullable

The period (in days) within which the license cannot be reassigned

LicenseMobilityApplies

Type: boolean

1 if eligible for bringing your own license to cloud environment

NumberOfOSEPerLicense

Type: integer. Nullable

Number of OSE per license

NumberOfProcessorsPerOSE

Type: integer. Nullable

Number of processors per OSE

TotalNumberOfCoresPerV MPerLicense

Type: integer. Nullable

Total number of cores per VM per license

NumberOfCoresPerSocket

Type: integer. Nullable

Number of cores per socket

ThirdPartyAccessAllowed

Type: boolean

Access to applications is allowed to third party users. This field is defaulted to True

AllowExternalRoamingUse

Type: boolean. Nullable

Set this field to True if license allows external roaming use. This field is defaulted to False. This is applicable for both device and user licenses and is related to virtual application access. If 1, this license will consume 1 entitlement per each user. If 0, this license will consume 1 license per each user device. And, if NULL, ignore virtual application access. This can be used in conjunction with VirtualApplicationAccessMaximumUsagePeriod.

MeasurementDate

Type: datetime. Nullable

The date of the license measurment.

ConsumptionUnit

Type: text. Nullable

Unit description to describe the consumption amount.

TargetOperatingSystem TypeID

Type: integer

Type of Operating Systems to target

VirtualApplication AccessMaximumUsage PeriodDevice

Type: integer. Nullable

This is a rule for virtual application access. This is used in conjunction with the AllowExternalRoamingUse. For Device licenses, a license will consume 1 entitlement per each user device when used in period specified here.

VirtualApplication AccessMaximumUsage PeriodUser

Type: integer. Nullable

This is a rule for virtual application access. This is used in conjunction with the AllowExternalRoamingUse. For user licenses, if 1, this license will consume only when used in period specified here.

AlwaysInstalled

Type: boolean

If this field is True, this license is considered in to be used whenever it is allocated. If False, software usage is considered separately, and allocation merely defines the corporation’s modelling of who is expected to consume entitlements.

MinimumNumberOf LicensesPerVM

Type: integer

When licensing a Virtual Hardware System with a MSServerCore license (LicenseTypeID = 33), consume license entitlements as though the virtual machine had at least this number of virtual threads.

AllowIBMPVUSubCapacity FromNonILMT

Type: boolean

If the license does not use host processor information (not full capacity), set this field to True to allow non-ILMT sub-capacity PVU consumption calculations to be used.

NumberOfAllowed ProcessorsPerHost

Type: integer. Nullable

This field specifies how many processors per host are allowed before an additional license entitlement (or point) is consumed. Null provides the default of 1. Zero provides unlimited.

MinimumNumberOfProcessors

Type: integer

The minimum number of processors that this license is for. This field is only used where the SoftwareLicenseType is MSServerProcessor (LicenseTypeID = 22).

LogicalProcessorsPer Server

Type: integer. Nullable

Number of logical processors per server on Cloud Service Provider Instances