Provance ITAM Software Datawarehouse Library

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

Management Pack Elements

Show Management Pack References

Resources

Resource (2)

Reporting

DataWarehouseScript (1)

Warehouse

Dimension (14)
Outrigger (8)
RelationshipFact (31)
WarehouseModule (1)

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