ConsumptionData Table
Stores all consumption information required by the external Consumption Fact.
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 |
|---|---|
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. |