Provance ITAM Software Usage Datawarehouse Library

Provance.ServiceManager.Itam.SoftwareUsage.Datawarehouse.V2 :: 2.0.8006.0 (Management Pack)

• Show Management Pack XML
• Get Management Pack data in Excel format
• Provance.ServiceManager.Itam.Software.mpb

Management Pack Elements

Resources (6)

	ID	File Name	Accessibility
	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProcResource	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProc.sql	Public
	TransformSoftwareUsageMonthlyUsageCountFactProcResource	TransformSoftwareUsageMonthlyUsageCountFactProc.sql	Public
	TransformSoftwareUsageMonthlyUsageTimeFactProcResource	TransformSoftwareUsageMonthlyUsageTimeFactProc.sql	Public
	UninstallSoftwareUsageMonthlyTerminalServiceUsageCountFactProcResource	UninstallSoftwareUsageMonthlyTerminalServiceUsageCountFactProc.sql	Public
	UninstallSoftwareUsageMonthlyUsageCountFactProcResource	UninstallSoftwareUsageMonthlyUsageCountFactProc.sql	Public
	UninstallSoftwareUsageMonthlyUsageTimeFactProcResource	UninstallSoftwareUsageMonthlyUsageTimeFactProc.sql	Public

Data Warehouse Scripts (3)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProc	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProcResource	UninstallSoftwareUsageMonthlyTerminalServiceUsageCountFactProcResource	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProcResource	False	Public
	TransformSoftwareUsageMonthlyUsageCountFactProc	TransformSoftwareUsageMonthlyUsageCountFactProcResource	UninstallSoftwareUsageMonthlyUsageCountFactProcResource	TransformSoftwareUsageMonthlyUsageCountFactProcResource	False	Public
	TransformSoftwareUsageMonthlyUsageTimeFactProc	TransformSoftwareUsageMonthlyUsageTimeFactProcResource	UninstallSoftwareUsageMonthlyUsageTimeFactProcResource	TransformSoftwareUsageMonthlyUsageTimeFactProcResource	False	Public

Dimensions (2)

	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	MonthlySoftwareUsageDim	Provance.Itam.SoftwareUsage.MonthlySoftwareUsage	True	IncludeExtendedClassProperties	False	Public
	SoftwareMeteringRuleDim	Provance.Itam.SoftwareUsage.SoftwareMeteringRule	True	IncludeExtendedClassProperties	False	Public

Relationship Facts (4)

	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	MeteringRuleSoftwareVersionFact	Domain.ITAssetManagement	Daily	Provance.Itam.SoftwareUsage.SoftwareMeteringRule	SoftwareMeteringRuleDim	Public
	MonthlySoftwareUsageComputerFact	Domain.ITAssetManagement	Daily	Provance.Itam.SoftwareUsage.MonthlySoftwareUsage	MonthlySoftwareUsageDim	Public
	MonthlySoftwareUsageMeteringRuleFact	Domain.ITAssetManagement	Daily	Provance.Itam.SoftwareUsage.MonthlySoftwareUsage	MonthlySoftwareUsageDim	Public
	MonthlySoftwareUsageUserFact	Domain.ITAssetManagement	Daily	Provance.Itam.SoftwareUsage.MonthlySoftwareUsage	MonthlySoftwareUsageDim	Public

Facts (3)

	ID	Domain	Time Grain	Accessibility
	SoftwareUsageMonthlyTerminalServiceUsageCountFact	Domain.ITAssetManagement	Daily	Public
	SoftwareUsageMonthlyUsageCountFact	Domain.ITAssetManagement	Daily	Public
	SoftwareUsageMonthlyUsageTimeFact	Domain.ITAssetManagement	Daily	Public

Warehouse Modules (3)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFact	TransformSoftwareUsageMonthlyTerminalServiceUsageCountFactProc	Transform	SoftwareUsageMonthlyTerminalServiceUsageCountFact	Public
	TransformSoftwareUsageMonthlyUsageCountFact	TransformSoftwareUsageMonthlyUsageCountFactProc	Transform	SoftwareUsageMonthlyUsageCountFact	Public
	TransformSoftwareUsageMonthlyUsageTimeFact	TransformSoftwareUsageMonthlyUsageTimeFactProc	Transform	SoftwareUsageMonthlyUsageTimeFact	Public