ImportedSoftwareLicense Table

FlexNet Manager Suite (Cloud)

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 (Cloud)

Current