SoftwareLicense Table

SoftwareLicense contains details of the software licenses managed by IT Asset Management.

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 IT Asset Management 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
`MinimumNumberOfUsers MultipliedByServers`	Type: boolean If the MinimumNumberOfUsers field is a multiple of the number of servers consuming from the license. This is used for `Oracle Named User Plus` licenses.
`UUID`	Type: unique identifier The UUID of the software license for external reference.