SoftwareLicensePointsRule Table

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