DB Table storing the License SnapShot details

[emtmeta]

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

[ChrisG · Accepted solution]

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
)