SoftwareLicensePointsDefault Table

The SoftwareLicensePointsDefault table stores a collection of default license points associated with a particular license type.

Table 1. Database columns for SoftwareLicensePointsDefault table

Database Column

Details

SoftwareLicensePoints DefaultID

Type: integer. Key. Generated ID

A unique identifier for a default points record.

SoftwareLicenseTypeID

Type: integer. Key

The software license type to which this points record applies. Foreign key to the SoftwareLicenseType table.

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 aas “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.

Points

Type: decimal

The points value per core or processor.

DateEffective

Type: datetime. Nullable

The date from which these default values are effective. This is used to group sets of rows into sets.

Description

Type: text (max 1024 characters). Nullable

A description of the points rules.