ConsumptionData Table

Stores all consumption information required by the external Consumption Fact.

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

Database Column

Details

ConsumptionDataID

Type: integer. Generated ID

A unique identifier for this consumption data.

SnapshotID

Type: integer. Key

The snapshot to which this consumption data pertains. Reference to the snapshot dimension.

SoftwareLicenseID

Type: integer. Key

The license to which this consumption data pertains. Reference to the software license dimension.

LocationID

Type: integer. Key

The location which has consumed this license.

CorporateUnitID

Type: integer. Key

The corporate unit which has consumed this license.

CostCenterID

Type: integer. Key

The cost center which has consumed this license.

CategoryID

Type: integer. Key

The category which classifies this license consumption.

InstalledCount

Type: integer. Nullable

Number of installed software records, linked to the license. It is not a number of application installations.

ConsumedCount

Type: integer

The number of licenses consumed.

UsedCount

Type: integer

The number of license consumptions that were used.

SecondUseCount

Type: integer

The number of installations which are not consuming a license as a result of second use rights.

DowngradeCount

Type: integer

The number of licenses consumed which are a result of downgrade rights.

VirtualEnvironmentCount

Type: integer

The number of installations which are not consuming a license as a result of virtual machine product use rights.

VMNonConsumedCount

Type: integer. Nullable

Count that is not consumed because of VM second use rights.

ExemptCount

Type: integer

The number of installations which are exempt from consuming a license.

LicensedCores

Type: integer. Nullable

The number of processor cores that are covered by a license.