SoftwareLicense Table

FlexNet Manager Suite (Cloud)

SoftwareLicense contains details of the software licenses managed by FlexNet Manager Suite.

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 SoftwareLicense table

Database Column

Details

SoftwareLicenseID

Type: integer. Key. Generated ID

A unique identifier for a software license.

ParentLicenseID

Type: integer. Key. Nullable

The id of any bundle that this license is a part of.

Name

Type: text (max 256 characters). Key

Name of the license.

Version

Type: text (max 60 characters). Key. Nullable

Version of the license.

Edition

Type: text (max 60 characters). Nullable

Edition of the license.

LicenseTypeID

Type: integer. Key

The license type. Foreign key to the SoftwareLicenseType table.

SoftwareLicenseMetricID

Type: integer. Nullable

Custom licensing metric for this license. Foreign key to the SoftwareLicenseMetric table.

DurationID

Type: integer

The duration of this license. Foreign key to the SoftwareLicenseDuration table.

SoftwareLicense ComplianceStatusID

Type: integer

The compliance status of this license. Foreign key to the SoftwareLicenseComplianceStatus table. Defaults to “Compliant”.

LicenseStatusID

Type: integer

The status of this license. Foreign key to the LicenseStatus table.

SoftwareLicense PurchaseTypeID

Type: integer. Nullable

The kind of purchase. Foreign key to the SoftwareLicensePurchaseType table.

VendorID

Type: integer. Key. Nullable

The vendor from whom the license was purchased. Foreign key to the Vendor table.

PublisherID

Type: integer. Key. Nullable

The software publisher associated with this license. Foreign key to the Vendor table.

ManagerID

Type: integer. Key. Nullable

The manager of this license. Foreign key to the ComplianceUser table.

PartNo

Type: text (max 100 characters). Nullable

The publisher’s part number for this license.

SerialNumber

Type: text (max 256 characters). Nullable

The serial number of the license.

LicenseKeyTypeID

Type: integer

The type of license keys managed on this license. Foreign key to the SoftwareLicenseKeyType table. Defaults to “No key”.

LicenseKey

Type: text (max 256 characters). Nullable

The multiple-use license key of the license. Only used when the license key type is a multi-use key (for example, an Enterprise key used to cover multiple installs).

RequestNo

Type: text (max 60 characters). Nullable

The request number for the license.

AcquisitionModeID

Type: integer

The method of acquisition used for the asset this license covers. Defaults to Purchased. Foreign key to the AcquisitionMode table.

PurchaseOrderNumber

Type: text (max 50 characters). Nullable

The purchase order number which was used to purchase the license.

PurchaseOrderDate

Type: datetime. Nullable

The original purchase order date for the license.

PurchasePrice

Type: currency. Nullable

The initial purchase price of the license.

PurchasePriceRateID

Type: integer. Nullable

The currency rate applied to the purchase price of the license. Foreign key to the CurrencyRate table.

ChargeBackPrice

Type: currency. Nullable

Amount to be charged for each computer on which the license is installed.

ChargeBackPriceRateID

Type: integer. Nullable

The currency rate applied to the charge-back price. Foreign key to the CurrencyRate table.

ChargeBackPeriodTypeID

Type: integer

The frequency with which the charge back price is charged. Defaults to None. Foreign key to the PeriodType table.

ExpiryDate

Type: datetime. Nullable

The date this license expires. A NULL value means the license does not expire.

DeliveryDate

Type: datetime. Nullable

The date this license became active. A NULL value means the license is inactive.

RetirementDate

Type: datetime. Nullable

The date this license was retired. A NULL value means the license is active.

WarrantyExpiryDate

Type: datetime. Nullable

The date the warranty on this license expires. This refers to a warranty Contract associated with the license.

NumberOfProcessors

Type: integer

The number of processors that this license is for. This field is only used where the SoftwareLicenseType is Device (Processor-Limited) (LicenseTypeID = 11).

NumberOfCores

Type: integer

The number of cores per processor that this license is for. This field is only used where the SoftwareLicenseType is Device (Core-Limited) (LicenseTypeID = 14).

NumberOfSockets

Type: integer

The number of sockets that this license is for. The value zero is reserved to mean unlimited. This field is only used where the SoftwareLicenseType is Oracle Processor (LicenseTypeID = 16) or Oracle Named User Plus (LicenseTypeID = 17).

MinimumNumberOfProcessors

Type: integer

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

MinimumNumberOf LicensesPerVM

Type: integer

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

MSPool

Type: text (max 120 characters). Nullable

The name of the Microsoft license pool to which the license belongs.

MSPoints

Type: integer

The points value of each installed version of this license, for use when calculating Microsoft licensing reports. This field is only valid when the MSPool field is set.

WarrantyTypeID

Type: integer

The type of warranty for the license. Defaults to None. Foreign key to the AssetWarrantyType table.

EndOfLifeRecipient

Type: text (max 128 characters). Nullable

The person or organization who received the asset associated with this license when it was disposed of.

EndOfLifeReasonID

Type: integer

The reason the asset was associated with this license was disposed of. Foreign key to the EndOfLifeReason table.

ResalePrice

Type: currency. Nullable

The amount the asset associated with this license was sold for.

ResalePriceRateID

Type: integer. Nullable

The currency rate to be applied to the sale price of the asset associated with this license.

CreationUser

Type: text (max 256 characters). Nullable

The operator who created this license.

CreationDate

Type: datetime

The date and time the license was created.

UpdatedUser

Type: text (max 256 characters). Nullable

The oeprator who last updated this license.

UpdatedDate

Type: datetime. Nullable

The date and time the license was last updated.

Comments

Type: text. Nullable

Comments about the license recorded by an operator. This field may also be used for storing license keys.

NumberPurchased

Type: integer

The quantity of purchased license entitlements.

NumberInstalled

Type: integer

The quantity of software installations accounted for by this license. This value is calculated and updated during the data import process, based on the software inventory details imported.

NumberCalculated

Type: integer

The calculated consumption value for this license.

ResourceUnitsConsumed

Type: decimal

The quantity consumed of a resource relevant to this license. The type of resource is identified by the associated SoftwareLicenseMetric. On the IBM Resource Value Unit license type this will have a points rule set applied to it to calculate the final license consumption value.

PeakConsumed

Type: integer

This value has been deprecated and is no longer used.

AdditionalBulkUsers Regular

Type: integer

A number of regular users associated with this license in addition to those specified individually in SoftwareLicenseAllocation. For IBM User Value Unit licenses this will have a points rule set applied to it to calculate the final license consumption value.

AdditionalBulkUsers Infrequent

Type: integer

A number of infrequent users associated with this license in addition to those specified individually in SoftwareLicenseAllocation. For IBM User Value Unit licenses this will have an infrequent user multiplier and points rule set applied to it to calculate the final license consumption value.

AdditionalBulkUsers External

Type: integer

A number of external users associated with this license in addition to those specified individually in SoftwareLicenseAllocation. For IBM User Value Unit licenses this will have an external user multiplier and points rule set applied to it to calculate the final license consumption value.

UserMultiplierInfrequent

Type: decimal

The fraction of a regular user’s consumption to use for infrequent users.

UserMultiplierExternal

Type: decimal

The fraction of a regular user’s consumption to use for external users.

NumberUsed

Type: integer

The number of software installations covered by this license that are actually being used.

NumberAllocated

Type: integer

The quantity of license entitlements allocated to individual end-users or computers.

NumberAssigned

Type: integer

The quantity of license entitlements that have been assigned to enterprise groups.

NumberOverridden

Type: integer

The quantity of overriden consumption allocated to individual end-users or computers.

LastCalculatedNUPMinimum

Type: integer. Nullable

The last calculated minimum for Oracle Named User Plus licenses.

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.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location linked to this license. Foreign key to the GroupEx table.

BusinessUnitID

Type: text (max 128 characters). Key. Nullable

Any enterprise corporate unit linked to this license. Foreign key to the GroupEx table.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise that is linked to this license. Foreign key to the GroupEx table.

CategoryID

Type: text (max 128 characters). Key. Nullable

Any enterprise category associated with this license. Foreign key to the GroupEx table.

CoverInstallsOnVirtual Machines

Type: boolean

This is known in the UI as “Enable special handling for virtual machines”.

Its effect usually includes enabling sub-capacity licensing of virtual installs and/or capping of license consumption at the host level, but its exact effect depends on the specific license type.

For license types that expose additional virtualization properties, this property must be set for the other properties to be used.

LimitNumberOfVirtual Installs

Type: boolean

If this field is True, there is a limit to the number of installations on virtual machines that can be covered by each license entitlement. If False, one license entitlement may cover use on any number of virtual machines (typically on one host computer).

NumberOfAllowedVirtual Installs

Type: integer. Nullable

If the license covers installations on virtual machines, this field specifies how many installations per host are allowed before an additional license entitlement (or point) is consumed.

LimitVirtualInstalls IncludesHost

Type: boolean

If this field is True, the host operating system installations are included in the overall count of operating systems on the host when there is a limit on the number of allowed virtual installs for each license. If False, the host operating system is not considered when determining virtual install limits.

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.

UseHostProcessor Information

Type: boolean

If virtual installs are allowed, set this field to True if host information should be used when calculating license points consumed.

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.

LimitNumberOf ApplicationsEach LicensePointCovers

Type: boolean

If this field is True, there is a limit on the number of application installations allowed per license entitlement (or point). If False (the default), then a license entitles you to any number of installations of software linked to this license on the one computer.

NumberOfApplication InstallsAllowedPer LicensePoint

Type: integer. Nullable

Where the previous field is set to True, this field defines the limited number of application installations allowed per entitlement (or point).

LimitNumberOfComputers UserLicenseCanBe InstalledOn

Type: boolean

If this field is True, there is a limit to the number of computers that a user-based license can be linked to per entitlement (or point) consumed. If False (the default), a single end-user is entitled to install related software for his/her own use on any number of computers.

NumberOfComputers AllowedPerUserLicense Point

Type: integer. Nullable

Where the previous field is set to True, this field defines the limited number of application installations an end-user is allowed per entitlement (or point).

MinimumNumberOfUsers

Type: integer

The minimum number of users allowed for the license. This is used for Oracle Named User Plus licenses.

MinimumNumberOfUsers MultipliedByProcessors

Type: boolean

Whether the previous field a fixed value for the license or it is a multiple of the number of processor points consumed by the license. This is used for Oracle Named User Plus licenses.

SecondUsageWorkLaptop

Type: boolean

If this field is True, the license confers the right of second use on a work laptop. If False, there is no right of second use allowed on a work laptop.

SecondUsageAtHome

Type: boolean

If this field is True, the license confers the right of second use on a home computer by the same end-user as the primary end-user of the license entitlement consumed at work. If False (the default), there is no right of second use allowed on a home computer.

MultiUseInheritFrom Contract

Type: boolean

Set this field to True if the license should inherit the values for right of multiple use from a contract.

MultiUseInheritFrom ContractID

Type: integer. Nullable

If the previous field is True, this is the contract that right of multiple use is inherited from. Foreign key to Contract table.

SecondUsageInheritFrom Contract

Type: boolean

Set this field to True if the license should inherit the values for right of second use from a contract.

SecondUsageInheritFrom ContractID

Type: integer. Nullable

If the previous field is True, this is the contract that right of second use is inherited from. Foreign key to Contract table.

CoverInstallsOnVM InheritFromContract

Type: boolean

Set this field to True if the license should inherit virtual machine rights from a contract.

CoverInstallsOnVM InheritFromContractID

Type: integer. Nullable

If the previous field is True, this is the contract that virtual machine rights are inherited from. Foreign key to Contract table.

AutoManageTitles

Type: boolean

Set this field to True if the license should have its application links automatically managed for upgrade and downgrade rights. When this field is False, the operator must manually manage links between this license and any applications.

DowngradeOnlyToVersion Legacy

Type: text (max 60 characters). Nullable

A repository for backward-compatible custom data.

UpgradeOnlyToVersion Legacy

Type: text (max 60 characters). Nullable

A repository for backward-compatible custom data.

TrueUp

Type: boolean

Set this field to True if the license is a true-up license (and so never goes into at risk).

UnlimitedConsumption

Type: boolean

Set this field to True if the license is a unlimited license (and so never goes into at risk).

OracleLegacyLicenseTypeID

Type: integer. Key. Nullable

The specific Oracle legacy license type, where appropriate. Foreign key to the OracleLegacyLicenseType table.

GroupAllocationTypeID

Type: integer. Key

Allocations of entitlements under any license can be made to only one type of enterprise group, specified here. Foreign key to the GroupType table.

GroupAllocation ReportingTypeID

Type: integer. Key

Determines when enterprise groups will be considered to have risked their allocations of entitlements under this license. Foreign key to the SoftwareLicenseGroupAllocationReportingType table.

GroupAllocation ComplianceLevel

Type: integer. Nullable

Determines the depth level of groups to be used for calculating the risk status for a license.

CannotManuallyUpdate GroupAssignments

Type: boolean

Set this field to True if the operator must make group assignments through a Assign License Entitlements dialog box. If False, changes can be made directly in the license properties pages.

CalculateCompliance

Type: boolean

When this field is True (the default), and the associated SoftwareLicenseType also has its CalculateCompliance field set to True (true for most license types), license consumption must be calculated from imported inventory. When False, the compliance state must be imported, not calculated.

IsSharableToLibrary

Type: boolean

Set this field to True (the default) if the license is sharable to the downloadable FlexNet Manager Suite ARL library.

CopyEditionAndVersion

Type: boolean

Set this field to True (the default) if edition and version should be automatically copied to the license from the primary application.

SoftwareLicenseTierTypeID

Type: integer. Key. Nullable

Type of the tier, for Tiered Device license type only. Foreign key to the SoftwareLicenseTierType table.

SoftwareLicenseTierCode

Type: text (max 256 characters). Nullable

The actual tier of the license, corresponding to the tier type. For Tiered Device license type only.

ImportedFromFNMEA

Type: boolean

Set this to True if this license was imported from FlexNet Manager for Engineering Applications.

SoftwareLicensePoints RuleSetID

Type: integer. Key. Nullable

The points rule set used to calculate compliance for this license. Foreign key to the SoftwareLicensePointsRuleSet table.

BaselineQuantity

Type: integer. Nullable

The baseline value for this license

BaselineDate

Type: datetime. Nullable

The date at which the baseline applies.

AlternateNon InventoriedUsers

Type: integer. Nullable

Number of non-inventoried users who are consuming this license. For Oracle Named User Plus and Oracle Application User licenses, this acts as an alternate mean to specify user consumption in the case where no instance users are available from inventory. The number of non-inventoried users are added to the number of unique users found from inventory when number installed and number used are calculated in license reconcile.

InheritLicenseMobility FromContract

Type: boolean

Set this field to True if this license inherits its license mobility rights from a contract. If False (the default), license mobility rights must be configured directly on the license properties.

InheritLicenseMobility FromContractID

Type: integer. Nullable

If the previous field is True, this is the contract that mobility rights are inherited from. Foreign key to the Contract table.

InheritLicense ConsumptionFromContract

Type: boolean

Set this field to True if this license inherits its license consumption rules from a contract. If False (the default), license consumption rules must be configured directly on the license properties.

InheritLicense ConsumptionFrom ContractID

Type: integer. Nullable

If the previous field is True, this is the contract that license consumption rules are inherited from. Foreign key to the Contract table.

InheritProcessorLimits FromContract

Type: boolean

Set this field to True if this license inherits its processor limits rights from a contract. If False (the default), license processor limits rights must be configured directly on the license properties.

InheritProcessorLimits FromContractID

Type: integer. Nullable

If the previous field is True, this is the contract that processor limits rights are inherited from. Foreign key to the Contract table.

AllowMaintenanceToExpire

Type: boolean

If the value True, maintenance added to license will not be renewed. If this flag is set, use rights for this license will be automatically updated once the maintenance expires.

AutoSynchronized

Type: boolean

If the value is True the license information will be synchronized with the information from the source connection.

UseRightsAutoUpdated

Type: boolean

If the value True, the use rights of this license has been automatically updated when all the maintenace expired. Else, use rights has not been updated.

SaasManagerLicenseID

Type: text (max 60 characters). Nullable

The Flexera SaaS Manager LicenseID

FlexNet Manager Suite (Cloud)

Current