In which backend database and table FNMS store the weekly license snapshot ?
i'm looking for weekly consumption snapshot for license with dates and required counts
Note : i would like to see the back end tables that feeds values for Compliance Trend report
Regards,
Junaid Vengadan
Oct 25, 2021 06:29 AM
Maybe start with the ConsumptionData view in the data warehouse database - this view gives consumption information for various snapshot points in time.
The data in this view is based on the following table:
CREATE TABLE dbo.ConsumptionData_MT (
-- A unique identifier for this consumption data.
ConsumptionDataID int IDENTITY NOT NULL,
-- The snapshot to which this consumption data pertains. Reference to the snapshot dimension.
SnapshotID int NOT NULL,
-- The license to which this consumption data pertains. Reference to the software license dimension.
SoftwareLicenseID int NOT NULL,
-- The location which has consumed this license.
LocationID int NOT NULL,
-- The corporate unit which has consumed this license.
CorporateUnitID int NOT NULL,
-- The cost center which has consumed this license.
CostCenterID int NOT NULL,
-- The category which classifies this license consumption.
CategoryID int NOT NULL,
-- Number of installed software records, linked to the license. It is not a number of application installations.
InstalledCount int NULL,
-- The number of licenses consumed.
ConsumedCount int NOT NULL,
-- The number of license consumptions that were used.
UsedCount int NOT NULL,
-- The number of installations which are not consuming a license as a result of second use rights.
SecondUseCount int NOT NULL,
-- The number of licenses consumed which are a result of downgrade rights.
DowngradeCount int NOT NULL,
-- The number of installations which are not consuming a license as a result of virtual machine product use rights.
VirtualEnvironmentCount int NOT NULL,
-- Count that is not consumed because of VM second use rights.
VMNonConsumedCount int NULL,
-- The number of installations which are exempt from consuming a license.
ExemptCount int NOT NULL,
-- The number of processor cores that are covered by a license.
LicensedCores int NULL,
-- The tenant ID in a multi-tenant database.
TenantID smallint NOT NULL
)
Oct 26, 2021 03:44 AM
Maybe start with the ConsumptionData view in the data warehouse database - this view gives consumption information for various snapshot points in time.
The data in this view is based on the following table:
CREATE TABLE dbo.ConsumptionData_MT (
-- A unique identifier for this consumption data.
ConsumptionDataID int IDENTITY NOT NULL,
-- The snapshot to which this consumption data pertains. Reference to the snapshot dimension.
SnapshotID int NOT NULL,
-- The license to which this consumption data pertains. Reference to the software license dimension.
SoftwareLicenseID int NOT NULL,
-- The location which has consumed this license.
LocationID int NOT NULL,
-- The corporate unit which has consumed this license.
CorporateUnitID int NOT NULL,
-- The cost center which has consumed this license.
CostCenterID int NOT NULL,
-- The category which classifies this license consumption.
CategoryID int NOT NULL,
-- Number of installed software records, linked to the license. It is not a number of application installations.
InstalledCount int NULL,
-- The number of licenses consumed.
ConsumedCount int NOT NULL,
-- The number of license consumptions that were used.
UsedCount int NOT NULL,
-- The number of installations which are not consuming a license as a result of second use rights.
SecondUseCount int NOT NULL,
-- The number of licenses consumed which are a result of downgrade rights.
DowngradeCount int NOT NULL,
-- The number of installations which are not consuming a license as a result of virtual machine product use rights.
VirtualEnvironmentCount int NOT NULL,
-- Count that is not consumed because of VM second use rights.
VMNonConsumedCount int NULL,
-- The number of installations which are exempt from consuming a license.
ExemptCount int NOT NULL,
-- The number of processor cores that are covered by a license.
LicensedCores int NULL,
-- The tenant ID in a multi-tenant database.
TenantID smallint NOT NULL
)
Oct 26, 2021 03:44 AM