Microsoft System Center Configuration Manager Data Warehouse Library

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

Management Pack Elements

Classes (1)

 IDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
InstallStatusTypeInstallStatusTypeSystem.LogicalEntityFalseFalseFalseFalseFalsePublic

Resources (4)

 IDFile NameAccessibility
TransformComputerHasSoftwareUpdateInstalledFactResourceTransformComputerHasSoftwareUpdateInstalledFactResourceTransformComputerHasSoftwareUpdateInstalledFact.sqlPublic
TransformPowerActivityDayFactResourceTransformPowerActivityDayFactResourceTransformPowerActivityDayFact.sqlPublic
UninstallComputerHasSoftwareUpdateInstalledFactResourceUninstallComputerHasSoftwareUpdateInstalledFactResourceUninstallComputerHasSoftwareUpdateInstalledFact.sqlPublic
UninstallPowerActivityDayFactResourceUninstallPowerActivityDayFactResourceUninstallPowerActivityDayFact.sqlPublic

Data Warehouse Scripts (2)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
TransformComputerHasSoftwareUpdateInstalledFactProcTransformComputerHasSoftwareUpdateInstalledFactProcTransformComputerHasSoftwareUpdateInstalledFactResourceUninstallComputerHasSoftwareUpdateInstalledFactResourceTransformComputerHasSoftwareUpdateInstalledFactResourceFalsePublic
TransformPowerActivityDayFactProcTransformPowerActivityDayFactProcTransformPowerActivityDayFactResourceUninstallPowerActivityDayFactResourceTransformPowerActivityDayFactResourceFalsePublic

Dimensions (5)

 DisplayNameIDTargetInferred DimensionHierarchy SupportReconcileAccessibility
ConfigurationManagerDeployedComputerDimConfiguration Manager Deployed Computer DimensionConfigurationManagerDeployedComputerDimMicrosoft.SystemCenter.ConfigurationManager.DeployedComputerTrueExactTruePublic
ConfigurationManagerCollectionDimConfigurationManagerCollectionDimConfigurationManagerCollectionDimMicrosoft.SystemCenter.ConfigurationManager.CollectionInfoTrueIncludeExtendedClassPropertiesTruePublic
PeripheralLogicalDiskDimPeripheralLogicalDiskDimPeripheralLogicalDiskDimMicrosoft.Windows.Peripheral.LogicalDiskTrueExactTruePublic
PeripheralProcessorDimPeripheralProcessorDimPeripheralProcessorDimMicrosoft.Windows.Peripheral.ProcessorTrueExactTruePublic
SoftwareUpdateDimSoftwareUpdateDimSoftwareUpdateDimSystem.SoftwareUpdateTrueIncludeDerivedClassPropertiesTruePublic

Outriggers (2)

 IDAccessibility
InstallStatusInstallStatusPublic
PowerActivityRecordEventTypePowerActivityRecordEventTypePublic

Measures (27)

 IDAggregationAccessibility
Hour0Hour0AdditivePublic
Hour1Hour1AdditivePublic
Hour10Hour10AdditivePublic
Hour11Hour11AdditivePublic
Hour12Hour12AdditivePublic
Hour13Hour13AdditivePublic
Hour14Hour14AdditivePublic
Hour15Hour15AdditivePublic
Hour16Hour16AdditivePublic
Hour17Hour17AdditivePublic
Hour18Hour18AdditivePublic
Hour19Hour19AdditivePublic
Hour2Hour2AdditivePublic
Hour20Hour20AdditivePublic
Hour21Hour21AdditivePublic
Hour22Hour22AdditivePublic
Hour23Hour23AdditivePublic
Hour3Hour3AdditivePublic
Hour4Hour4AdditivePublic
Hour5Hour5AdditivePublic
Hour6Hour6AdditivePublic
Hour7Hour7AdditivePublic
Hour8Hour8AdditivePublic
Hour9Hour9AdditivePublic
IsInstalledIsInstalledAdditivePublic
IsMissingIsMissingAdditivePublic
IsUnknownIsUnknownAdditivePublic

Relationship Facts (2)

 DisplayNameIDDomainTime GrainSource TypeSource DimensionAccessibility
DeployedComputerRunsWindowsComputerFactDeployed Computer Runs Windows Computer FactDeployedComputerRunsWindowsComputerFactDomain.CommonDailySystem.ComputerHardwareDeployedComputerDimPublic
ConfigurationManagerCollectionHasComputerConfigurationManagerCollectionHasComputerConfigurationManagerCollectionHasComputerDomain.CommonDailyMicrosoft.SystemCenter.ConfigurationManager.CollectionInfoConfigurationManagerCollectionDimPublic

Facts (2)

 IDDomainTime GrainAccessibility
ComputerHasSoftwareUpdateInstalledFactComputerHasSoftwareUpdateInstalledFactDomain.ConfigurationManagerDailyPublic
PowerActivityDayFactPowerActivityDayFactDomain.ConfigurationManagerDailyPublic

Warehouse Modules (2)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformComputerHasSoftwareUpdateInstalledFactTransformComputerHasSoftwareUpdateInstalledFactTransformComputerHasSoftwareUpdateInstalledFactProcTransformComputerHasSoftwareUpdateInstalledFactPublic
TransformPowerActivityDayFactTransformPowerActivityDayFactTransformPowerActivityDayFactProcTransformPowerActivityDayFactPublic