cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DB Table storing the License SnapShot details

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

(1) Solution
ChrisG
By Community Manager Community Manager
Community Manager

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
)
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)

View solution in original post

(1) Reply
ChrisG
By Community Manager Community Manager
Community Manager

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
)
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)