SoftwareLicenseSnapshot Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The SoftwareLicenseSnapshot table lists all the snapshotted software licenses.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The snapshotted SoftwareLicenseID.

Name

Type: text (max 256 characters)

The snapshotted license name.

LicenseTypeID

Type: integer. Key

The license type. Foreign key to the SoftwareLicenseType table.

SoftwareLicense ComplianceStatusID

Type: integer. Nullable

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

Consumed

Type: integer. Nullable

The snapshotted license consumed count.

PurchaseQuantity

Type: integer. Nullable

The snapshotted license purchase quantity.

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.

LicenseMeasurementID

Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.

NumberUsed

Type: integer. Nullable

The snapshotted license number used count.

LastCalculatedNUPMinimum

Type: integer. Nullable

The snapshotted license last calculated minimum for Oracle Named User Plus licenses.

CalculatedConsumed

Type: integer

The calculated consumption value for this license.

FlexNet Manager Suite (On-Premises)

2020 R1