Microsoft SQL Server 2014 (Views)

Microsoft.SQLServer.2014.Views :: 7.0.4.0 (Management Pack)

This Management Pack contains views and folder structure for Microsoft SQL Server 2014 management packs.

Management Pack Elements

Classes (9)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2014.AgentsGroupSQL Server 2014 Agents GroupMicrosoft.SQLServer.2014.AgentsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.AlertsScopeGroupL3MSSQL 2014: Alerts Scope Group L3Microsoft.SQLServer.2014.AlertsScopeGroupL3System.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityMSSQL 2014: Group of High Availability GroupsMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilitySystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupGroupMSSQL 2014: Group of Availability GroupsMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaGroupMSSQL 2014: Group of Availability ReplicasMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaGroupMSSQL 2014: Group of Database ReplicasMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.DatabasesGroupSQL Server 2014 Databases GroupMicrosoft.SQLServer.2014.DatabasesGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.InstancesGroupSQL Server 2014 Instance GroupMicrosoft.SQLServer.2014.InstancesGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2014.MirroringGroupsGroupSQL Server 2014 Mirroring Groups GroupMicrosoft.SQLServer.2014.MirroringGroupsGroupSystem.GroupFalseFalseTrueTrueFalsePublic

Relationship Types (9)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2014.AgentsGroupContainsAgentSQL Server 2014 Agents Group Contains AgentMicrosoft.SQLServer.2014.AgentsGroupContainsAgentMicrosoft.SQLServer.2014.AgentsGroupMicrosoft.SQLServer.2014.AgentPublicFalse
Microsoft.SQLServer.2014.DatabasesGroupContainsDatabaseSQL Server 2014 Databases Group Contains DatabaseMicrosoft.SQLServer.2014.DatabasesGroupContainsDatabaseMicrosoft.SQLServer.2014.DatabasesGroupMicrosoft.SQLServer.2014.DatabasePublicFalse
Microsoft.SQLServer.2014.GlobalInstanceGroupContainsDBEngineMSSQL : SQL Server Instance Group Contains InstancesMicrosoft.SQLServer.2014.GlobalInstanceGroupContainsDBEngineMicrosoft.SQLServer.Generic.Presentation.SQLServerInstanceGroupMicrosoft.SQLServer.2014.DBEnginePublicFalse
Microsoft.SQLServer.2014.InstancesGroupContainsDBEngineSQL Server 2014 Instances Group Contains DBEngineMicrosoft.SQLServer.2014.InstancesGroupContainsDBEngineMicrosoft.SQLServer.2014.InstancesGroupMicrosoft.SQLServer.2014.DBEnginePublicFalse
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsAlertsScopeGroupL3Alerts Scope Group Contains Alerts Scope Group L3 RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsAlertsScopeGroupL3Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2014.AlertsScopeGroupL3InternalFalse
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsSeedAlerts Scope Group Contains Seed RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsSeedMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2014.SeedInternalFalse
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupL3ContainsEventLogCollectionTargetAlerts Scope Group L3 Contains Event Log Collection Target RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupL3ContainsEventLogCollectionTargetMicrosoft.SQLServer.2014.AlertsScopeGroupL3Microsoft.SQLServer.2014.EventLogCollectionTargetInternalFalse
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupL3ContainsServiceRolesAlertsScopeGroupL3ContainsServiceRole RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupL3ContainsServiceRolesMicrosoft.SQLServer.2014.AlertsScopeGroupL3Microsoft.SQLServer.2014.ServerRoleInternalFalse
Microsoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRolesServer Roles Group Contains Server Roles RelationshipMicrosoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRolesMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupMicrosoft.SQLServer.2014.ServerRoleInternalFalse

Discoveries (8)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2014.AgentsGroup.DiscoveryMSSQL 2014: Populate SQL Server 2014 Agents GroupMicrosoft.SQLServer.2014.AgentsGroup.DiscoveryMicrosoft.SQLServer.2014.AgentsGroupTrue
Microsoft.SQLServer.2014.AlertsScopeGroupDiscoveryMSSQL 2014: Alerts Scope Group DiscoveryMicrosoft.SQLServer.2014.AlertsScopeGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupTrue
Microsoft.SQLServer.2014.DatabasesGroup.DiscoveryMSSQL 2014: Populate SQL Server 2014 Databases GroupMicrosoft.SQLServer.2014.DatabasesGroup.DiscoveryMicrosoft.SQLServer.2014.DatabasesGroupTrue
Microsoft.SQLServer.2014.Discovery.AlertsScopeGroupL3MSSQL 2014: Alerts Scope Group L3 DiscoveryMicrosoft.SQLServer.2014.Discovery.AlertsScopeGroupL3Microsoft.SQLServer.2014.AlertsScopeGroupL3True
Microsoft.SQLServer.2014.GenericComputerGroupDiscoveryMSSQL 2014: Discover SQL Server Computer Group membershipMicrosoft.SQLServer.2014.GenericComputerGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ComputersGroupTrue
Microsoft.SQLServer.2014.GlobalInstanceGroupDiscoveryMSSQL: Populate SQL Server Instance GroupMicrosoft.SQLServer.2014.GlobalInstanceGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerInstanceGroupTrue
Microsoft.SQLServer.2014.InstancesGroup.DiscoveryMSSQL 2014: Populate SQL Server 2014 Instance GroupMicrosoft.SQLServer.2014.InstancesGroup.DiscoveryMicrosoft.SQLServer.2014.InstancesGroupTrue
Microsoft.SQLServer.2014.ServerRolesGroupDiscoveryMSSQL 2014: Server Roles Group DiscoveryMicrosoft.SQLServer.2014.ServerRolesGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupTrue

Folder Items (20)

 DisplayNameIDFolderNameElementID
Microsoft.SQLServer.2014.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Agent.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.Agent.AlertsView
Microsoft.SQLServer.2014.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2014.Agent.StateViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.Agent.StateView
Microsoft.SQLServer.2014.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2014.AgentJob.StateViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.AgentJob.StateView
Microsoft.SQLServer.2014.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Database.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.AlertsView
Microsoft.SQLServer.2014.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.Database.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.AllPerformanceDataView
Microsoft.SQLServer.2014.Database.StateViewDatabasesMicrosoft.SQLServer.2014.Database.StateViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.StateView
Microsoft.SQLServer.2014.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2014.DBEngine.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.AlertsView
Microsoft.SQLServer.2014.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataView
Microsoft.SQLServer.2014.DBEngine.ResourcePoolsViewResource PoolsMicrosoft.SQLServer.2014.DBEngine.ResourcePoolsViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.ResourcePoolsView
Microsoft.SQLServer.2014.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2014.DBEngine.StateViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.StateView
Microsoft.SQLServer.2014.DBFileGroup.StateViewFilegroupsMicrosoft.SQLServer.2014.DBFileGroup.StateViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.DBFileGroup.StateView
Microsoft.SQLServer.2014.Server.StateViewComputersMicrosoft.SQLServer.2014.Server.StateViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.Server.StateView
Microsoft.SQLServer.2014.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsView
Microsoft.SQLServer.2014.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataView
Microsoft.SQLServer.2014.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2014.ServerRole.TaskStatusViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.TaskStatusView
Microsoft.SQLServer.2014.View.Container.StateMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.2014.View.Container.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.Container.State
Microsoft.SQLServer.2014.View.DBFileGroupFx.StateMemory-Optimized Data FilegroupsMicrosoft.SQLServer.2014.View.DBFileGroupFx.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.DBFileGroupFx.State
Microsoft.SQLServer.2014.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2014.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.InMemoryOLTP.Alerts
Microsoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceData
Microsoft.SQLServer.2014.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2014.View.UserResourcePool.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.UserResourcePool.State

Folders (5)

 DisplayNameIDParentFolderAccessibility
Microsoft.SQLServer.2014.ViewFolder.AgentSQL AgentMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.DatabasesDatabasesMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.DBEnginesDatabase EnginesMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.InMemoryOLTPMemory-Optimized DataMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.ViewFolder.DatabasesPublic
Microsoft.SQLServer.2014.ViewFolder.RootSQL Server 2014Microsoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.Generic.Presentation.Folder.DatabaseEnginePublic

Views (23)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.2014.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Agent.AlertsViewMicrosoft.SQLServer.2014.AgentMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2014.Agent.StateViewMicrosoft.SQLServer.2014.AgentMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2014.AgentJob.StateViewMicrosoft.SQLServer.2014.AgentJobMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Database.AlertsViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.Database.AllPerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.DBSizePerformanceDataViewDatabase Free SpaceMicrosoft.SQLServer.2014.Database.DBSizePerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.LogSizePerformanceDataViewTransaction Log Free SpaceMicrosoft.SQLServer.2014.Database.LogSizePerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.StateViewDatabasesMicrosoft.SQLServer.2014.Database.StateViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2014.DBEngine.AlertsViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.ResourcePoolsViewResource PoolsMicrosoft.SQLServer.2014.DBEngine.ResourcePoolsViewMicrosoft.SQLServer.2014.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2014.DBEngine.StateViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.UserConnectionsViewUser ConnectionsMicrosoft.SQLServer.2014.DBEngine.UserConnectionsViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.DBFileGroup.StateViewFilegroupsMicrosoft.SQLServer.2014.DBFileGroup.StateViewMicrosoft.SQLServer.2014.FileGroupMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.Server.StateViewComputersMicrosoft.SQLServer.2014.Server.StateViewMicrosoft.Windows.ComputerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2014.AlertsScopeGroupL3Microsoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2014.ServerRoleMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2014.ServerRole.TaskStatusViewMicrosoft.SQLServer.2014.ServerRoleMicrosoft.SystemCenter.TaskStatusViewTypePublicTrue
Microsoft.SQLServer.2014.View.Container.StateMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.2014.View.Container.StateMicrosoft.SQLServer.2014.ContainerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.View.DBFileGroupFx.StateMemory-Optimized Data FilegroupsMicrosoft.SQLServer.2014.View.DBFileGroupFx.StateMicrosoft.SQLServer.2014.DBFileGroupFxMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2014.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2014.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2014.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2014.View.UserResourcePool.StateMicrosoft.SQLServer.2014.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue