SoftwareLicensePointsRule Table
The SoftwareLicensePointsRule
table stores individual license points rules (mapping of criteria to point value) belonging to a given points rule set.
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.
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 
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 humanreadable 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 
CoverAllCloudProviders

Type: boolean If the value 
IsShared

Type: boolean 
FlexNet Manager Suite (Cloud)
Current