SoftwareLicenseProduct Table

FlexNet Manager Suite 2020 R1 (On-Premises)

SoftwareLicenseProduct contains the set of SoftwareTitleProducts covered by a SoftwareLicense. Their product specific use rights on this license are also covered.

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 `SoftwareLicenseProduct` table
Database Column	Details
`SoftwareLicenseProductID`	Type: integer. Key. Generated ID A unique identifier for a software license product.
`SoftwareLicenseID`	Type: integer. Key License whose property value is being stored. Foreign key to the `SoftwareLicense` table
`SoftwareTitleProductID`	Type: integer. Key. Nullable The product covered by this license. Foreign key to the `SoftwareTitleProduct` table.
`CurrentSoftwareTitleID`	Type: integer. Nullable Identifies the current application for this product on this license (which may change over time as upgrade rights are applied). Foreign key to the `SoftwareTitle` table.
`Supplementary`	Type: boolean Whether this product on this license is supplementary (counted for consumption) or not.
`MeasuredForCompliance`	Type: boolean Whether this product on this license is measured for compliance risks.
`ProductRatio`	Type: integer If this product is supplementary on the license, the number of entitlements consumed related to the entitlements consumed for the parent product.
`ParentProductRatio`	Type: integer If this product is supplementary on the license, the number of entitlements consumed related to the entitlements consumed for the supplementary product.
`InheritDowngradeFrom Contract`	Type: boolean Set this field to `True` if this license inherits its downgrade rights from a contract. If `False` (the default), downgrade rights must be configured directly on the license properties.
`InheritDowngradeFrom ContractID`	Type: integer. Nullable If the previous field is `True`, this is the contract that downgrade rights are inherited from. Foreign key to the `Contract` table.
`InheritUpgradeFrom Contract`	Type: boolean Set this field to `True` if this license inherits its upgrade rights from a contract. If `False` (the default), upgrade rights must be configured directly on the license properties.
`InheritUpgradeFrom ContractID`	Type: integer. Nullable If the previous field is `True`, this is the contract that downgrade rights are inherited from. Foreign key to the `Contract` table.
`DowngradeEnabled`	Type: boolean If this field is `True`, this license can cover previous releases, or lower editions, of applications linked to this license. If this field is `False` (the default), there is no downgrade right conferred by this license.
`DowngradeToVersion`	Type: boolean If this field is `True`, the license covers previous releases (with the same edition) of the primary application. If this field is `False` (the default), earlier versions of the primary application are not covered by downgrade rights.
`DowngradeToVersionID`	Type: integer. Nullable If the previous field is `True` and the value of this field is NULL, downgrade rights cover all earlier releases (with the same edition) of the primary application. If not NULL, downgrade rights cover all versions of the primary application down to and including this version. Foreign key to the `SoftwareTitleVersion` table.
`DowngradeToEdition`	Type: boolean If this field is `True`, the license covers lower editions (with the same version) of the primary application. If this field is `False` (the default), lower editions of the primary application are not covered by downgrade rights.
`DowngradeToEditionID`	Type: integer. Nullable If the previous field is `True` and the value of this field is NULL, downgrade rights cover all lower editions (with the same version) of the primary application. If not NULL, downgrade rights cover all editions of the primary application down to and including this edition. Foreign key to the `SoftwareTitleEdition` table.
`UpgradeEnabled`	Type: boolean If this field is `True`, the license can cover future releases (with the same edition) of the primary application. If this bit is `False` (the default), there is no upgrade right conferred by this license.
`UpgradeToVersion`	Type: boolean If this field is `True`, the license covers later releases (with the same edition) of the primary application. If this field is `False` (the default), later versions of the primary application are not covered by upgrade rights.
`UpgradeToVersionID`	Type: integer. Nullable If the previous field is `True` and the value of this field is NULL, upgrade rights cover all later version (with the same edition) of the primary application. If not NULL, upgrade rights cover all versions of the primary application up to and including this version. Foreign key to the `SoftwareTitleEdition` table.
`UpgradeUntil`	Type: boolean If this bit is 1, the upgrade right covers future releases of applications that get linked to this license, provided that the release date of each version is before (or on) a specified date. If this bit is zero (the default), the upgrade right is not date limited.
`UpgradeUntilDate`	Type: datetime. Nullable If this field is set, only applications released before this date are covered by upgrade rights.

FlexNet Manager Suite (On-Premises)

2020 R1