ImportedSoftwareLicense Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The ImportedSoftwareLicense table holds all of the licenses which have been retrieved from the source connections.

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 `ImportedSoftwareLicense` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`ExternalLicenseID`	Type: big integer. Key. Nullable The identifier used in the source connection for the license.
`LicenseName`	Type: text (max 256 characters). Nullable The name of the license.
`SoftwareLicenseTypeID`	Type: integer. Nullable The license type ID of the license.
`EntitlementCount`	Type: integer. Nullable The number of entitlements for the license.
`IsSubscription`	Type: boolean Indicates whether or not the license is a subscription license.
`ExpiryDate`	Type: datetime. Nullable The expiry date of a subscription license.
`PartNo`	Type: text (max 100 characters). Nullable The publisher’s part number for this license.
`SoftwareLicenseID`	Type: integer. Nullable Identifier of the license in the `SoftwareLicense` table that this imported license links to. This is populated by the import process and does not need to be provided by the source connections.
`VirtualApplication AccessMaximumUsagePeriod`	Type: integer. Nullable This is a rule for virtual application access. This is used in conjunction with the AllowExternalRoamingUse. For Device licenses, a license will consume 1 entitlement per each user device when used in period specified here. For user licenses, if 1, this license will consume only when used in period specified here.
`PublisherName`	Type: text (max 64 characters). Nullable The name of the publisher.
`Version`	Type: text (max 60 characters). Nullable The name of the Version.
`Edition`	Type: text (max 60 characters). Nullable The name of the Edition.
`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).
`SaasManagerLicenseID`	Type: text (max 60 characters). Nullable The Flexera SaaS Manager LicenseID

FlexNet Manager Suite (On-Premises)

2020 R1