Provance ITAM-Software-Data Warehouse-Bibliothek

Provance.ServiceManager.Itam.Software.Datawarehouse :: 2.0.8006.0 (Management Pack)

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

Management Pack Elements

Resources (2)

	ID	File Name	Accessibility
	TransformSoftwareTitleHasOwnersFactProcResource	TransformSoftwareTitleHasOwnersFactProc.sql	Public
	UninstallTransformSoftwareTitleHasOwnersFactProcResource	UninstallTransformSoftwareTitleHasOwnersFactProc.sql	Public

Data Warehouse Scripts (1)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformSoftwareTitleHasOwnersFactProc	TransformSoftwareTitleHasOwnersFactProcResource	UninstallTransformSoftwareTitleHasOwnersFactProcResource	TransformSoftwareTitleHasOwnersFactProcResource	False	Public

Dimensions (14)

	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	ExcludedSoftwareItemGroupDim	Provance.ITAM.ExcludedSoftwareItemGroup	True	IncludeExtendedClassProperties	False	Public
	SkuDim	Provance.ITAM.Sku	True	IncludeExtendedClassProperties	False	Public
	SoftwareAdminSettingsDim	Provance.ITAM.SoftwareAdminSettings	True	IncludeExtendedClassProperties	False	Public
	SoftwareAllocationDim	Provance.ITAM.Allocation	True	IncludeExtendedClassProperties	False	Public
	SoftwareAllocationSetDim	Provance.ITAM.AllocationSet	True	IncludeExtendedClassProperties	False	Public
	SoftwareAssignmentDim	Provance.ITAM.Assignment	True	IncludeExtendedClassProperties	False	Public
	SoftwareAssignmentSetDim	Provance.ITAM.AssignmentSet	True	IncludeExtendedClassProperties	False	Public
	SoftwareItemDim	System.SoftwareItem	True	IncludeExtendedClassProperties	False	Public
	SoftwareLicenseDim	Provance.ITAM.SoftwareLicense	True	IncludeExtendedClassProperties	False	Public
	SoftwareLicenseKeyDim	Provance.ITAM.SoftwareLicenseKey	True	IncludeExtendedClassProperties	False	Public
	SoftwareTitleDim	Provance.ITAM.SoftwareTitle	True	IncludeExtendedClassProperties	False	Public
	SoftwareVersionDim	Provance.ITAM.SoftwareVersion	True	IncludeExtendedClassProperties	False	Public
	SWLicenseAgtDim	Provance.ITAM.SoftwareLicenseAgreement	True	IncludeExtendedClassProperties	False	Public
	SWMaintAgtDim	Provance.ITAM.SoftwareMaintenanceAgreement	True	IncludeExtendedClassProperties	False	Public

Outriggers (8)

	ID	Accessibility
	ApprovalStatus	Public
	LicensePricing	Public
	LicenseType	Public
	LicenseUnit	Public
	LicensingProgram	Public
	OwnerType	Public
	SoftwareAllocationType	Public
	SoftwareCategory	Public

Relationship Facts (31)

	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	DeviceInstalledSoftwareItemFact	Domain.ITAssetManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	ExcludedSoftwareItemGroupSoftwareItemFact	Domain.ITAssetManagement	Daily	Provance.ITAM.ExcludedSoftwareItemGroup	ExcludedSoftwareItemGroupDim	Public
	LicenseSWMaintAgtFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	PublisherSoftwareTitleFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Company	CompanyDim	Public
	SkuHasDowngradeSoftwareVersionsFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Sku	SkuDim	Public
	SkuHasUpgradeSoftwareVersionsFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Sku	SkuDim	Public
	SkuPublisherFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Sku	SkuDim	Public
	SkuSoftwareTitleFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Sku	SkuDim	Public
	SkuSoftwareVersionFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Sku	SkuDim	Public
	SoftwareAllocationConfigItemTargetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Allocation	SoftwareAllocationDim	Public
	SoftwareAllocationSetAllocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.AllocationSet	SoftwareAllocationSetDim	Public
	SoftwareAssignmentConfigItemTargetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Assignment	SoftwareAssignmentDim	Public
	SoftwareAssignmentLicenseKeyFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Assignment	SoftwareAssignmentDim	Public
	SoftwareAssignmentSetAssignmentFact	Domain.ITAssetManagement	Daily	Provance.ITAM.AssignmentSet	SoftwareAssignmentSetDim	Public
	SoftwareAssignmentSoftwareLicenseFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Assignment	SoftwareAssignmentDim	Public
	SoftwareCostCenterFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareLicenseSkuFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareLicenseSoftwareLicenseKeyFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareLocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareOrganizationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareSupplierFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SoftwareTitleAllocationSetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareTitle	SoftwareTitleDim	Public
	SoftwareTitleAssignmentSetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareTitle	SoftwareTitleDim	Public
	SoftwareTitleHasOwnersFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareTitle	SoftwareTitleDim	Public
	SoftwareTitleVersionFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareTitle	SoftwareTitleDim	Public
	SWAgreementContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicenseAgreement	SWLicenseAgtDim	Public
	SWAgreementLicenseFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicense	SoftwareLicenseDim	Public
	SWLicenseAgtPublisherFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareLicenseAgreement	SWLicenseAgtDim	Public
	SWMaintAgtContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareMaintenanceAgreement	SWMaintAgtDim	Public
	SWMaintAgtPublisherFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareMaintenanceAgreement	SWMaintAgtDim	Public
	VersionDiscoveredItemFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SoftwareVersion	SoftwareVersionDim	Public

Warehouse Modules (1)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformSoftwareTitleHasOwnersFact	TransformSoftwareTitleHasOwnersFactProc	Transform	SoftwareTitleHasOwnersFact	Public