SoftwareLicense Table
SoftwareLicense
contains details of the software licenses managed by FlexNet Manager Suite.
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.
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 |
SoftwareLicenseMetricID
|
Type: integer. Nullable Custom licensing metric for this license. Foreign key to the |
DurationID
|
Type: integer The duration of this license. Foreign key to the |
SoftwareLicense ComplianceStatusID
|
Type: integer The compliance status of this license. Foreign key to the |
LicenseStatusID
|
Type: integer The status of this license. Foreign key to the |
SoftwareLicense PurchaseTypeID
|
Type: integer. Nullable The kind of purchase. Foreign key to the |
VendorID
|
Type: integer. Key. Nullable The vendor from whom the license was purchased. Foreign key to the |
PublisherID
|
Type: integer. Key. Nullable The software publisher associated with this license. Foreign key to the |
ManagerID
|
Type: integer. Key. Nullable The manager of this license. Foreign key to the |
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 |
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 |
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 |
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 |
ChargeBackPeriodTypeID
|
Type: integer The frequency with which the charge back price is charged. Defaults to |
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 |
NumberOfProcessors
|
Type: integer The number of processors that this license is for. This field is only used where the |
NumberOfCores
|
Type: integer The number of cores per processor that this license is for. This field is only used where the |
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 |
MinimumNumberOfProcessors
|
Type: integer The minimum number of processors that this license is for. This field is only used where the
|
MinimumNumberOf LicensesPerVM
|
Type: integer When licensing a Virtual Hardware System with a |
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 |
WarrantyTypeID
|
Type: integer The type of warranty for the license. Defaults to |
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 |
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 |
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 |
AdditionalBulkUsers Infrequent
|
Type: integer A number of infrequent users associated with this license in addition to those specified
individually in |
AdditionalBulkUsers External
|
Type: integer A number of external users associated with this license in addition to those specified
individually in |
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 |
AlwaysInstalled
|
Type: boolean If this field is |
LocationID
|
Type: text (max 128 characters). Key. Nullable Any enterprise location linked to this license. Foreign key to the |
BusinessUnitID
|
Type: text (max 128 characters). Key. Nullable Any enterprise corporate unit linked to this license. Foreign key to the |
CostCenterID
|
Type: text (max 128 characters). Key. Nullable Any cost center in the enterprise that is linked to this license. Foreign key to the |
CategoryID
|
Type: text (max 128 characters). Key. Nullable Any enterprise category associated with this license. Foreign key to the |
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 |
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 |
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 |
AllowIBMPVUSubCapacity FromNonILMT
|
Type: boolean If the license does not use host processor information (not full capacity), set this field to |
LimitNumberOf ApplicationsEach LicensePointCovers
|
Type: boolean If this field is |
NumberOfApplication InstallsAllowedPer LicensePoint
|
Type: integer. Nullable Where the previous field is set to |
LimitNumberOfComputers UserLicenseCanBe InstalledOn
|
Type: boolean If this field is |
NumberOfComputers AllowedPerUserLicense Point
|
Type: integer. Nullable Where the previous field is set to |
MinimumNumberOfUsers
|
Type: integer The minimum number of users allowed for the license. This is used for |
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 |
SecondUsageWorkLaptop
|
Type: boolean If this field is |
SecondUsageAtHome
|
Type: boolean If this field is |
MultiUseInheritFrom Contract
|
Type: boolean Set this field to |
MultiUseInheritFrom ContractID
|
Type: integer. Nullable If the previous field is |
SecondUsageInheritFrom Contract
|
Type: boolean Set this field to |
SecondUsageInheritFrom ContractID
|
Type: integer. Nullable If the previous field is |
CoverInstallsOnVM InheritFromContract
|
Type: boolean Set this field to |
CoverInstallsOnVM InheritFromContractID
|
Type: integer. Nullable If the previous field is |
AutoManageTitles
|
Type: boolean Set this field to |
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 |
UnlimitedConsumption
|
Type: boolean Set this field to |
OracleLegacyLicenseTypeID
|
Type: integer. Key. Nullable The specific Oracle legacy license type, where appropriate. Foreign key to the |
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 |
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 |
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 |
CalculateCompliance
|
Type: boolean When this field is |
IsSharableToLibrary
|
Type: boolean Set this field to |
CopyEditionAndVersion
|
Type: boolean Set this field to |
SoftwareLicenseTierTypeID
|
Type: integer. Key. Nullable Type of the tier, for |
SoftwareLicenseTierCode
|
Type: text (max 256 characters). Nullable The actual tier of the license, corresponding to the tier type. For |
ImportedFromFNMEA
|
Type: boolean Set this to |
SoftwareLicensePoints RuleSetID
|
Type: integer. Key. Nullable The points rule set used to calculate compliance for this license. Foreign key to the |
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 |
InheritLicenseMobility FromContract
|
Type: boolean Set this field to |
InheritLicenseMobility FromContractID
|
Type: integer. Nullable If the previous field is |
InheritLicense ConsumptionFromContract
|
Type: boolean Set this field to |
InheritLicense ConsumptionFrom ContractID
|
Type: integer. Nullable If the previous field is |
InheritProcessorLimits FromContract
|
Type: boolean Set this field to |
InheritProcessorLimits FromContractID
|
Type: integer. Nullable If the previous field is |
AllowMaintenanceToExpire
|
Type: boolean If the value |
AutoSynchronized
|
Type: boolean If the value is |
UseRightsAutoUpdated
|
Type: boolean If the value |
SaasManagerLicenseID
|
Type: text (max 60 characters). Nullable The Flexera SaaS Manager LicenseID |
FlexNet Manager Suite (On-Premises)
2020 R1