SoftwareLicensePointsRule Table

FlexNet Manager Suite (Cloud)

The SoftwareLicensePointsRule table stores individual license points rules (mapping of criteria to point value) belonging to a given points rule set.

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

Database Column

Details

SoftwareLicensePoints RuleID

Type: integer. Key. Generated ID

A unique identifier for a points rule record.

SoftwareLicensePoints RuleSetID

Type: integer. Key

The set to which this rule applies. Foreign key to the SoftwareLicensePointsRuleSet table.

IsCustom

Type: boolean. Key

True if the rule is managed by the customer (versus by the ARL).

Description

Type: text (max 1024 characters). Nullable

A human-readable description or identifier for the rule.

Points

Type: decimal. Key

The points value per core, processor, user, or other resource metric.

ProcessorType

Type: text (max 256 characters)

The type of processor a computer must have for this criterion to apply, such as “AMD” or “Intel”.

ComputerModelNo

Type: text (max 128 characters)

The model number a computer must have for this criterion to apply, such as “IBM PS701” or “IBM JS12”.

MinCores

Type: integer

The minimum number of processor cores a computer must have for this criterion to apply.

MaxCores

Type: integer

The maximum number of processor cores a computer must have for this criterion to apply.

MinProcessors

Type: integer

The minimum number of processors a computer must have for this criterion to apply.

MaxProcessors

Type: integer

The maximum number of processors a computer must have for this criterion to apply.

MinSockets

Type: integer

The minimum number of processor sockets a computer must have for this criterion to apply.

MaxSockets

Type: integer

The maximum number of processor sockets a computer must have for this criterion to apply.

MinCoresPerSocket

Type: integer

The minimum number of processor cores per socket a computer must have for this criterion to apply.

MaxCoresPerSocket

Type: integer

The maximum number of processor cores per socket a computer must have for this criterion to apply.

MinResource

Type: decimal. Key

The minimum resource value for an IBM RVU license for this criterion to apply.

MaxResource

Type: decimal. Key

The maximum resource value for an IBM RVU license for this criterion to apply.

MinUsers

Type: integer. Key

The minimum number of users relevant to an IBM UVU license for this criterion to apply.

MaxUsers

Type: integer. Key

The maximum number of users relevant to an IBM UVU license for this criterion to apply.

MinClockSpeed

Type: integer

The minimum value of the highest frequency of fastest processor, measured in megaherz, for this criterion to apply.

MaxClockSpeed

Type: integer

The maximum value of the highest frequency of fastest processor, measured in megaherz, for this criterion to apply.

MinPurchaseDate

Type: datetime. Nullable

The earliest date on which the asset must have been purchased for this criterion to apply.

MaxPurchaseDate

Type: datetime. Nullable

The latest date on which the asset must have been purchased for this criterion to apply.

CoverOnPremise

Type: boolean

If the value True, the points rule created can be used on-premises devices

CoverAllCloudProviders

Type: boolean

If the value True, the points rule created can be used on all cloud service providers. If the value is False, list of cloud providers could be found from SoftwareLicensePointsRuleCloudServiceProvider table

IsShared

Type: boolean

FlexNet Manager Suite (Cloud)

Current