SoftwareLicenseData Table

This table stores each of the Software Licenses known to FNMP. This maps directly to the External Software License Dimension. This is not a slowly changing dimension, but a snapshot of current and deleted license information. If license properties change from one snapshot to the next, the information in this table will be updated.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

Unique identifier for this license from the FNMP database.

ProductName

Type: text (max 1024 characters)

Product name of the primary application of this license.

PublisherName

Type: text (max 64 characters). Nullable

The name of the publisher

LicenseName

Type: text (max 256 characters)

The name of this license.

LicenseVersion

Type: text (max 60 characters). Nullable

The version of this license.

LicenseEdition

Type: text (max 60 characters). Nullable

The edition of this license.

LicenseTypeID

Type: integer

ID of the type of this license.

LicenseType

Type: text (max 256 characters)

The type of this license.

GrantsSecondUse

Type: boolean

Whether this license offers second use rights.

GrantsDowngrade

Type: boolean

Whether this license offers downgrade rights.

IsTrueUp

Type: boolean

Whether this license provides True Up functionality.

UnlimitedConsumption

Type: boolean

Whether this license provides unlimited consumption.

EstimatedUnitPrice

Type: currency. Nullable

Estimated Unit price for the license

GrantsVirtualEnvironment

Type: boolean

Whether installs of this license on a virtual machine host covers installations on virtual machines hosted by that host.

UseInSecondUseRights

Type: boolean

A Boolean field that states whether product use rights apply to this license type.

NumberPurchased

Type: integer

The quantity of purchased license entitlements.

LocationID

Type: integer. Key

The location which owns this license.

CorporateUnitID

Type: integer. Key

The corporate unit which owns this license.

CostCenterID

Type: integer. Key

The cost center which owns this license.

CategoryID

Type: integer. Key

The category of this license.

LicenseStatusID

Type: integer

ID of the status of this license

LicenseStatus

Type: text (max 256 characters)

License Status of the license

ComplianceStatusID

Type: integer

ID of the compliance status of this license

ComplianceStatus

Type: text (max 256 characters)

Compliance Status of the license

DurationID

Type: integer

ID of duration of this license

Duration

Type: text (max 256 characters)

The name of the resource string containing the text to display on the user interface.

ExpiryDate

Type: datetime. Nullable

The date this license expires. A NULL value means the license does not expire.