emtmeta asked a question.
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
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)
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: