SoftwareLicenseGroupPointsConsumedData Table

SoftwareLicenseGroupPointsConsumed records the licenses pre-calculated local and rolledup totals for groups.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The license that owns the pre-calculated totals for a group. Foreign key to the SoftwareLicense table.

GroupTypeID

Type: integer. Key

Type of the group(Location, Cost center, etc)

GroupExID

Type: text (max 128 characters). Key. Nullable

The group where the local and rolledup values are calculated. Foreign key to the GroupEx table.

RolledUpNumberConsumed

Type: integer

The sum of points consumed of the current group and of all its child groups.

LocalNumberConsumed

Type: integer

The sum of points consumed of the current group

RolledUpNumberUsed

Type: integer

The sum of used points f the current group and of all its child groups.

LocalNumberUsed

Type: integer

The sum of used points of the current group

RolledUpNumberPurchased

Type: big integer

The rolled up purchase counts of the license.

LocalNumberPurchased

Type: big integer

The local purchase counts of the license

LicenseMeasurementID

Type: integer. Key

The license measurement ID. Foreign key to the LicenseMeasurement table.

RolledUpNumberCalculated

Type: integer

The sum of points calculated for the current group and of all its child groups.

LocalNumberCalculated

Type: integer

The sum of points calculated for the current group.