System Center Data Warehouse Base Library

Microsoft.SystemCenter.Datawarehouse.Base :: 10.19.1035.0 (Management Pack)

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

Management Pack Elements

Classes (6)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	Data Warehouse Base Managed Type	Microsoft.SystemCenter.Datawarehouse.Base.ManagedType	System.Entity	True	False	False	False	False	Public
	Data Warehouse Base Management Pack	Microsoft.SystemCenter.Datawarehouse.Base.ManagementPack	System.Entity	True	False	False	False	False	Public
	Data Warehouse Base Relationship Type	Microsoft.SystemCenter.Datawarehouse.Base.RelationshipType	System.Entity	True	False	False	False	False	Public
	Data Warehouse CMDB Source	Microsoft.SystemCenter.DataWarehouse.CMDBSource	Microsoft.SystemCenter.DataWarehouse.DataSource	False	False	False	False	False	Public
	Data Warehouse Data Source	Microsoft.SystemCenter.DataWarehouse.DataSource	System.AdminItem	True	False	False	False	False	Public
	Data Warehouse Management Pack	Microsoft.SystemCenter.DataWarehouse.ManagementPack	System.AdminItem	False	False	False	False	False	Public

Relationship Types (1)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	Is Related to Management Pack	DataSourceAssociatesManagementPack	Microsoft.SystemCenter.DataWarehouse.DataSource	Microsoft.SystemCenter.DataWarehouse.ManagementPack	Public	False

Enumerations (33)

	DisplayName	ID	Parent	Accessibility
	Base Domain	Domain		Public
	Activity Management	Domain.ActivityManagement	Domain	Public
	Change Management	Domain.ChangeManagement	Domain	Public
	Configuration Management	Domain.ConfigurationManagement	Domain	Public
	Incident Management	Domain.IncidentManagement	Domain	Public
	Instance Management	Domain.InstanceManagement	Domain	Public
	Orchestration	Domain.Orchestration	Domain	Public
	Problem Management	Domain.ProblemManagement	Domain	Public
	Release Management	Domain.ReleaseManagement	Domain	Public
	Service Catalog	Domain.ServiceCatalog	Domain	Public
	Datasource Type	DW.DatasourceType		Internal
	Linking Framework	DW.DatasourceType.LinkingFramework	DW.DatasourceType	Internal
	Operations Manager	DW.DatasourceType.OperationsManager	DW.DatasourceType	Internal
	Service Manager	DW.DatasourceType.ServiceManager	DW.DatasourceType	Internal
	Unknown	DW.DatasourceType.Unknown	DW.DatasourceType	Internal
	Source Action	DW.SourceAction		Internal
	Registered	DW.SourceAction.Registered	DW.SourceAction	Internal
	Unregistered	DW.SourceAction.UnRegistered	DW.SourceAction	Internal
	Domain.Common	Domain.Common	Domain	Public
	Domain.ConfigurationManager	Domain.ConfigurationManager	Domain	Public
	Domain.OperationsManager	Domain.OperationsManager	Domain	Public
	Domain.SLAManagement	Domain.SLAManagement	Domain	Public
	DW.SourceStatus	DW.SourceStatus		Internal
	DW.SourceStatus.Disabled	DW.SourceStatus.Disabled	DW.SourceStatus	Internal
	DW.SourceStatus.Enabled	DW.SourceStatus.Enabled	DW.SourceStatus	Internal
	DW.Transform.Template	DW.Transform.Template		Public
	DW.Transform.Template.AbstractDimension	DW.Transform.Template.AbstractDimension	DW.Transform.Template	Public
	DW.Transform.Template.AbstractSingleRelationshipFact	DW.Transform.Template.AbstractSingleRelationshipFact	DW.Transform.Template	Public
	DW.Transform.Template.ConcreteDimension	DW.Transform.Template.ConcreteDimension	DW.Transform.Template	Public
	DW.Transform.Template.ConcreteSingleRelationshipFact	DW.Transform.Template.ConcreteSingleRelationshipFact	DW.Transform.Template	Public
	DW.Transform.Template.MultiRelationshipFact	DW.Transform.Template.MultiRelationshipFact	DW.Transform.Template	Public
	DW.Transform.Template.Outrigger	DW.Transform.Template.Outrigger	DW.Transform.Template	Public
	DW.Transform.Template.StateTransition	DW.Transform.Template.StateTransition	DW.Transform.Template	Public

Resources (18)

	ID	File Name	Accessibility
	TransformDataSourceDimResource	TransformDataSourceDim.sql	Public
	TransformEntityDimResource	TransformEntityDim.sql	Public
	TransformEntityManagedTypeFactResource	TransformEntityManagedTypeFact.sql	Public
	TransformEntityRelatesToEntityFactResource	TransformEntityRelatesToEntityFact.sql	Public
	TransformGroupContainsConfigItemFactResource	TransformGroupContainsConfigItemFact.sql	Public
	TransformManagedTypeDimResource	TransformManagedTypeDim.sql	Public
	TransformManagementPackDimResource	TransformManagementPackDim.sql	Public
	TransformRelationshipTypeDimResource	TransformRelationshipTypeDim.sql	Public
	TransformServiceContainsConfigItemFactResource	TransformServiceContainsConfigItemFact.sql	Public
	UninstallDataSourceDimResource	UninstallDataSourceDim.sql	Public
	UninstallEntityDimResource	UninstallEntityDim.sql	Public
	UninstallEntityManagedTypeFactResource	UninstallEntityManagedTypeFact.sql	Public
	UninstallEntityRelatesToEntityFactResource	UninstallEntityRelatesToEntity.sql	Public
	UninstallManagedTypeDimResource	UninstallManagedTypeDim.sql	Public
	UninstallManagementPackDimResource	UninstallManagementPackDim.sql	Public
	UninstallRelationshipTypeDimResource	UninstallRelationshipTypeDim.sql	Public
	UninstallTransformGroupContainsConfigItemFactResource	UninstallTransformGroupContainsConfigItemFact.sql	Public
	UninstallTransformServiceContainsConfigItemFactResource	UninstallTransformServiceContainsConfigItemFact.sql	Public

Assemblies (1)

	ID	File Name	Accessibility
	Microsoft.SystemCenter.ManagedSource.Assembly	Microsoft.SystemCenter.ManagedSource.dll	Internal

Data Warehouse Scripts (9)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformDataSourceDimProc	TransformDataSourceDimResource	UninstallDataSourceDimResource	TransformDataSourceDimResource	False	Public
	TransformEntityDimProc	TransformEntityDimResource	UninstallEntityDimResource	TransformEntityDimResource	False	Public
	TransformEntityManagedTypeFactProc	TransformEntityManagedTypeFactResource	UninstallEntityManagedTypeFactResource	TransformEntityManagedTypeFactResource	False	Public
	TransformEntityRelatesToEntityFactProc	TransformEntityRelatesToEntityFactResource	UninstallEntityRelatesToEntityFactResource	TransformEntityRelatesToEntityFactResource	False	Public
	TransformGroupContainsConfigItemFactProc	TransformGroupContainsConfigItemFactResource	UninstallTransformGroupContainsConfigItemFactResource	TransformGroupContainsConfigItemFactResource	False	Public
	TransformManagedTypeDimProc	TransformManagedTypeDimResource	UninstallManagedTypeDimResource	TransformManagedTypeDimResource	False	Public
	TransformManagementPackDimProc	TransformManagementPackDimResource	UninstallManagementPackDimResource	TransformManagementPackDimResource	False	Public
	TransformRelationshipTypeDimProc	TransformRelationshipTypeDimResource	UninstallRelationshipTypeDimResource	TransformRelationshipTypeDimResource	False	Public
	TransformServiceContainsConfigItemFactProc	TransformServiceContainsConfigItemFactResource	UninstallTransformServiceContainsConfigItemFactResource	TransformServiceContainsConfigItemFactResource	False	Public

Dimensions (20)

	DisplayName	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	Billable Time Dim	BillableTimeDim	System.WorkItem.BillableTime	True	IncludeExtendedClassProperties	False	Public
	Computer Dim	ComputerDim	Microsoft.Windows.Computer	True	IncludeExtendedClassProperties	True	Public
	Config Item Dim	ConfigItemDim	System.ConfigItem	True	Exact	True	Public
	Config Item Group Dim	ConfigItemGroupDim	Microsoft.SystemCenter.ConfigItemGroup	True	IncludeExtendedClassProperties	True	Public
	Data Source Dim	DataSourceDim	Microsoft.SystemCenter.DataWarehouse.CMDBSource	True	Exact	True	Public
	Deployed Computer Dim	DeployedComputerDim	System.ComputerHardware	True	IncludeExtendedClassProperties	True	Public
	Entity Dim	EntityDim	System.Entity	True	Exact	False	Public
	Group Dim	GroupDim	System.Group	False	Exact	True	Public
	Logical Disk Dim	LogicalDiskDim	Microsoft.Windows.LogicalDisk	True	IncludeExtendedClassProperties	True	Public
	Managed Type Dim	ManagedTypeDim	Microsoft.SystemCenter.Datawarehouse.Base.ManagedType	True	IncludeExtendedClassProperties	False	Public
	Management Pack Dim	ManagementPackDim	Microsoft.SystemCenter.Datawarehouse.Base.ManagementPack	True	IncludeExtendedClassProperties	False	Public
	Network Adapter Dim	NetworkAdapterDim	Microsoft.Windows.NetworkAdapter	True	IncludeExtendedClassProperties	True	Public
	Operating System Dim	OperatingSystemDim	Microsoft.Windows.OperatingSystem	True	IncludeExtendedClassProperties	True	Public
	Physical Disk Dim	PhysicalDiskDim	Microsoft.Windows.PhysicalDisk	True	IncludeExtendedClassProperties	True	Public
	Processor Dim	ProcessorDim	Microsoft.Windows.Processor	True	IncludeExtendedClassProperties	True	Public
	Relationship Type Dim	RelationshipTypeDim	Microsoft.SystemCenter.Datawarehouse.Base.RelationshipType	True	IncludeExtendedClassProperties	False	Public
	Service Dim	ServiceDim	System.Service	True	Exact	True	Public
	User Dim	UserDim	System.Domain.User	True	IncludeDerivedClassProperties	True	Public
	Work Item Dim	WorkItemDim	System.WorkItem	True	Exact	False	Public
	Work Item Group Dim	WorkItemGroupDim	System.WorkItemGroup	True	Exact	False	Public

Outriggers (6)

	DisplayName	ID	Accessibility
	Action Type	ActionType	Public
	Config Item Asset Status	ConfigItemAssetStatus	Public
	Config Item Object Status	ConfigItemObjectStatus	Public
	Service Classification	ServiceClassification	Public
	Service Priority	ServicePriority	Public
	Service Status	ServiceStatus	Public

Relationship Facts (23)

	DisplayName	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	Billable Time Has Working User Fact	BillableTimeHasWorkingUserFact	Domain.InstanceManagement	Daily	System.WorkItem.BillableTime	BillableTimeDim	Public
	Computer Hosts Logical Disk Fact	ComputerHostsLogicalDiskFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	Computer Hosts Network Adapter Fact	ComputerHostsNetworkAdapterFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	Computer Hosts Operating System Fact	ComputerHostsOperatingSystemFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	Computer Hosts Physical Disk Fact	ComputerHostsPhysicalDiskFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	Computer Hosts Processor Fact	ComputerHostsProcessorFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	Config Item Group Contains Entities Fact	ConfigItemGroupContainsEntitiesFact	Domain.ConfigurationManagement	Daily	Microsoft.SystemCenter.ConfigItemGroup	ConfigItemGroupDim	Public
	Config Item Impacts Customers Fact	ConfigItemImpactsCustomersFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
	Config Item Owned By User Fact	ConfigItemOwnedByUserFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
	Config Item Relates To Config Item Fact	ConfigItemRelatesToConfigItemFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
	Config Item Serviced By User Fact	ConfigItemServicedByUserFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
	Service Impacts User Fact	ServiceImpactsUserFact	Domain.ConfigurationManagement	Daily	System.Service	ServiceDim	Public
	Work Item About Config Item Fact	WorkItemAboutConfigItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Affected User Fact	WorkItemAffectedUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Assigned To User Fact	WorkItemAssignedToUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Created By User Fact	WorkItemCreatedByUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Group Contains Work Item Fact	WorkItemGroupContainsWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItemGroup	WorkItemGroupDim	Public
	Work Item Has Billable Time Fact	WorkItemHasBillableTimeFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Relates To Config Item Fact	WorkItemRelatesToConfigItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Work Item Relates To Work Item Fact	WorkItemRelatesToWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	ComputerHasPrimaryUserFact	ComputerHasPrimaryUserFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
	WorkItemHasParentWorkItemFact	WorkItemHasParentWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	WorkItemImpactsServiceFact	WorkItemImpactsServiceFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public

Facts (4)

	DisplayName	ID	Domain	Time Grain	Accessibility
	Entity Managed Type Fact	EntityManagedTypeFact	Domain.InstanceManagement	Daily	Public
	Entity Relates To Entity Fact	EntityRelatesToEntityFact	Domain.InstanceManagement	Daily	Public
	Group Contains Config Item Fact	GroupContainsConfigItemFact	Domain.Common	Daily	Public
	Service Contains Config Item Fact	ServiceContainsConfigItemFact	Domain.Common	Daily	Public

Warehouse Modules (9)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformDataSourceDim	TransformDataSourceDimProc	Transform	DataSourceDim	Public
	TransformEntityDim	TransformEntityDimProc	Transform	EntityDim	Public
	TransformEntityManagedTypeFact	TransformEntityManagedTypeFactProc	Transform	EntityManagedTypeFact	Public
	TransformEntityRelatesToEntityFact	TransformEntityRelatesToEntityFactProc	Transform	EntityRelatesToEntityFact	Public
	TransformGroupContainsConfigItemFact	TransformGroupContainsConfigItemFactProc	Transform	GroupContainsConfigItemFact	Public
	TransformManagedTypeDim	TransformManagedTypeDimProc	Transform	ManagedTypeDim	Public
	TransformManagementPackDim	TransformManagementPackDimProc	Transform	ManagementPackDim	Public
	TransformRelationshipTypeDim	TransformRelationshipTypeDimProc	Transform	RelationshipTypeDim	Public
	TransformServiceContainsConfigItemFact	TransformServiceContainsConfigItemFactProc	Transform	ServiceContainsConfigItemFact	Public