Microsoft System Center Configuration Manager Data Warehouse Library

Microsoft.SystemCenter.ConfigurationManager.Datawarehouse :: 7.7.16.0 (Management Pack)

• Show Management Pack XML
• Get Management Pack data in Excel format
• SCCMDW.mpb

Management Pack Elements

Classes (1)

	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	InstallStatusType	System.LogicalEntity	False	False	False	False	False	Public

Resources (4)

	ID	File Name	Accessibility
	TransformComputerHasSoftwareUpdateInstalledFactResource	TransformComputerHasSoftwareUpdateInstalledFact.sql	Public
	TransformPowerActivityDayFactResource	TransformPowerActivityDayFact.sql	Public
	UninstallComputerHasSoftwareUpdateInstalledFactResource	UninstallComputerHasSoftwareUpdateInstalledFact.sql	Public
	UninstallPowerActivityDayFactResource	UninstallPowerActivityDayFact.sql	Public

Data Warehouse Scripts (2)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformComputerHasSoftwareUpdateInstalledFactProc	TransformComputerHasSoftwareUpdateInstalledFactResource	UninstallComputerHasSoftwareUpdateInstalledFactResource	TransformComputerHasSoftwareUpdateInstalledFactResource	False	Public
	TransformPowerActivityDayFactProc	TransformPowerActivityDayFactResource	UninstallPowerActivityDayFactResource	TransformPowerActivityDayFactResource	False	Public

Dimensions (5)

	DisplayName	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	Configuration Manager Deployed Computer Dimension	ConfigurationManagerDeployedComputerDim	Microsoft.SystemCenter.ConfigurationManager.DeployedComputer	True	Exact	True	Public
	ConfigurationManagerCollectionDim	ConfigurationManagerCollectionDim	Microsoft.SystemCenter.ConfigurationManager.CollectionInfo	True	IncludeExtendedClassProperties	True	Public
	PeripheralLogicalDiskDim	PeripheralLogicalDiskDim	Microsoft.Windows.Peripheral.LogicalDisk	True	Exact	True	Public
	PeripheralProcessorDim	PeripheralProcessorDim	Microsoft.Windows.Peripheral.Processor	True	Exact	True	Public
	SoftwareUpdateDim	SoftwareUpdateDim	System.SoftwareUpdate	True	IncludeDerivedClassProperties	True	Public

Outriggers (2)

	ID	Accessibility
	InstallStatus	Public
	PowerActivityRecordEventType	Public

Measures (27)

	ID	Aggregation	Accessibility
	Hour0	Additive	Public
	Hour1	Additive	Public
	Hour10	Additive	Public
	Hour11	Additive	Public
	Hour12	Additive	Public
	Hour13	Additive	Public
	Hour14	Additive	Public
	Hour15	Additive	Public
	Hour16	Additive	Public
	Hour17	Additive	Public
	Hour18	Additive	Public
	Hour19	Additive	Public
	Hour2	Additive	Public
	Hour20	Additive	Public
	Hour21	Additive	Public
	Hour22	Additive	Public
	Hour23	Additive	Public
	Hour3	Additive	Public
	Hour4	Additive	Public
	Hour5	Additive	Public
	Hour6	Additive	Public
	Hour7	Additive	Public
	Hour8	Additive	Public
	Hour9	Additive	Public
	IsInstalled	Additive	Public
	IsMissing	Additive	Public
	IsUnknown	Additive	Public

Relationship Facts (2)

	DisplayName	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	Deployed Computer Runs Windows Computer Fact	DeployedComputerRunsWindowsComputerFact	Domain.Common	Daily	System.ComputerHardware	DeployedComputerDim	Public
	ConfigurationManagerCollectionHasComputer	ConfigurationManagerCollectionHasComputer	Domain.Common	Daily	Microsoft.SystemCenter.ConfigurationManager.CollectionInfo	ConfigurationManagerCollectionDim	Public

Facts (2)

	ID	Domain	Time Grain	Accessibility
	ComputerHasSoftwareUpdateInstalledFact	Domain.ConfigurationManager	Daily	Public
	PowerActivityDayFact	Domain.ConfigurationManager	Daily	Public

Warehouse Modules (2)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformComputerHasSoftwareUpdateInstalledFact	TransformComputerHasSoftwareUpdateInstalledFactProc	Transform	ComputerHasSoftwareUpdateInstalledFact	Public
	TransformPowerActivityDayFact	TransformPowerActivityDayFactProc	Transform	PowerActivityDayFact	Public