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 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 |
CoverAllCloudProviders
|
Type: boolean If the value |
ByolEnabled
|
Type: boolean. Nullable Specifies if the points rule is applicable for the installation. |
IsShared
|
Type: boolean |