Microsoft SQL Server 2014 (Views)

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

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

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (9)
RelationshipType (9)

Monitoring

Discovery (8)

Presentation

FolderItem (19)
Folder (5)
View (22)

Classes (9)

System.Entity

System.LogicalEntity

System.Group

DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
SQL Server 2014 Agents Group	Microsoft.SQLServer.2014.AgentsGroup	System.Group	False	False	True	True	False	Public
MSSQL 2014: Alerts Scope Group L3	Microsoft.SQLServer.2014.AlertsScopeGroupL3	System.Group	False	False	True	True	False	Public
MSSQL 2014: Group of High Availability Groups	Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailability	System.Group	False	False	True	True	False	Public
MSSQL 2014: Group of Availability Groups	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupGroup	System.Group	False	False	True	True	False	Public
MSSQL 2014: Group of Availability Replicas	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaGroup	System.Group	False	False	True	True	False	Public
MSSQL 2014: Group of Database Replicas	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaGroup	System.Group	False	False	True	True	False	Public
SQL Server 2014 Databases Group	Microsoft.SQLServer.2014.DatabasesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2014 Instance Group	Microsoft.SQLServer.2014.InstancesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2014 Mirroring Groups Group	Microsoft.SQLServer.2014.MirroringGroupsGroup	System.Group	False	False	True	True	False	Public

Relationship Types (9)

DisplayName	ID	Source	Target	Accessibility	Abstract
SQL Server 2014 Agents Group Contains Agent	Microsoft.SQLServer.2014.AgentsGroupContainsAgent	Microsoft.SQLServer.2014.AgentsGroup	Microsoft.SQLServer.2014.Agent	Public	False
SQL Server 2014 Databases Group Contains Database	Microsoft.SQLServer.2014.DatabasesGroupContainsDatabase	Microsoft.SQLServer.2014.DatabasesGroup	Microsoft.SQLServer.2014.Database	Public	False
MSSQL : SQL Server Instance Group Contains Instances	Microsoft.SQLServer.2014.GlobalInstanceGroupContainsDBEngine	Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup	Microsoft.SQLServer.2014.DBEngine	Public	False
SQL Server 2014 Instances Group Contains DBEngine	Microsoft.SQLServer.2014.InstancesGroupContainsDBEngine	Microsoft.SQLServer.2014.InstancesGroup	Microsoft.SQLServer.2014.DBEngine	Public	False
Alerts Scope Group Contains Event Log Collection Target Relationship	Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsEventLogCollectionTarget	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	Microsoft.SQLServer.2014.EventLogCollectionTarget	Internal	False
Alerts Scope Group Contains Seed Relationship	Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsSeed	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	Microsoft.SQLServer.2014.Seed	Internal	False
AlertsScopeGroupContainsServiceRole Relationship	Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsServiceRoles	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	Microsoft.SQLServer.2014.ServerRole	Internal	False
AlertsScopeGroupL3ContainsServiceRole Relationship	Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupL3ContainsServiceRoles	Microsoft.SQLServer.2014.AlertsScopeGroupL3	Microsoft.SQLServer.2014.ServerRole	Internal	False
Server Roles Group Contains Server Roles Relationship	Microsoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRoles	Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup	Microsoft.SQLServer.2014.ServerRole	Internal	False

Discoveries (8)

DisplayName	ID	Target	Enabled
MSSQL 2014: Populate SQL Server 2014 Agents Group	Microsoft.SQLServer.2014.AgentsGroup.Discovery	Microsoft.SQLServer.2014.AgentsGroup	True
MSSQL 2014: Alerts Scope Group Discovery	Microsoft.SQLServer.2014.AlertsScopeGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	True
MSSQL 2014: Populate SQL Server 2014 Databases Group	Microsoft.SQLServer.2014.DatabasesGroup.Discovery	Microsoft.SQLServer.2014.DatabasesGroup	True
MSSQL 2014: Alerts Scope Group L3 Discovery	Microsoft.SQLServer.2014.Discovery.AlertsScopeGroupL3	Microsoft.SQLServer.2014.AlertsScopeGroupL3	True
MSSQL 2014: Discover SQL Server Computer Group membership	Microsoft.SQLServer.2014.GenericComputerGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.ComputersGroup	True
MSSQL: Populate SQL Server Instance Group	Microsoft.SQLServer.2014.GlobalInstanceGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup	True
MSSQL 2014: Populate SQL Server 2014 Instance Group	Microsoft.SQLServer.2014.InstancesGroup.Discovery	Microsoft.SQLServer.2014.InstancesGroup	True
MSSQL 2014: Server Roles Group Discovery	Microsoft.SQLServer.2014.ServerRolesGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup	True

Folder Items (19)

Folders (5)

DisplayName	ID	ParentFolder	Accessibility
SQL Agent	Microsoft.SQLServer.2014.ViewFolder.Agent	Microsoft.SQLServer.2014.ViewFolder.Root	Public
Databases	Microsoft.SQLServer.2014.ViewFolder.Databases	Microsoft.SQLServer.2014.ViewFolder.Root	Public
Database Engines	Microsoft.SQLServer.2014.ViewFolder.DBEngines	Microsoft.SQLServer.2014.ViewFolder.Root	Public
Memory-Optimized Data	Microsoft.SQLServer.2014.ViewFolder.InMemoryOLTP	Microsoft.SQLServer.2014.ViewFolder.Databases	Public
SQL Server 2014	Microsoft.SQLServer.2014.ViewFolder.Root	Microsoft.SQLServer.Generic.Presentation.Folder.DatabaseEngine	Public

Views (22)

DisplayName	ID	Target	Type	Accessibility	Visible
Active Alerts	Microsoft.SQLServer.2014.Agent.AlertsView	Microsoft.SQLServer.2014.Agent	Microsoft.SystemCenter.AlertViewType	Public	True
SQL Agents	Microsoft.SQLServer.2014.Agent.StateView	Microsoft.SQLServer.2014.Agent	Microsoft.SystemCenter.StateViewType	Public	True
SQL Agent Jobs	Microsoft.SQLServer.2014.AgentJob.StateView	Microsoft.SQLServer.2014.AgentJob	Microsoft.SystemCenter.StateViewType	Public	True
Active Alerts	Microsoft.SQLServer.2014.Database.AlertsView	Microsoft.SQLServer.2014.Database	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.2014.Database.AllPerformanceDataView	Microsoft.SQLServer.2014.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
Database Free Space	Microsoft.SQLServer.2014.Database.DBSizePerformanceDataView	Microsoft.SQLServer.2014.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
Transaction Log Free Space	Microsoft.SQLServer.2014.Database.LogSizePerformanceDataView	Microsoft.SQLServer.2014.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
Databases	Microsoft.SQLServer.2014.Database.StateView	Microsoft.SQLServer.2014.Database	Microsoft.SystemCenter.StateViewType	Public	True
Active Alerts	Microsoft.SQLServer.2014.DBEngine.AlertsView	Microsoft.SQLServer.2014.DBEngine	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.2014.DBEngine.AllPerformanceDataView	Microsoft.SQLServer.2014.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
Database Engines	Microsoft.SQLServer.2014.DBEngine.StateView	Microsoft.SQLServer.2014.DBEngine	Microsoft.SystemCenter.StateViewType	Public	True
User Connections	Microsoft.SQLServer.2014.DBEngine.UserConnectionsView	Microsoft.SQLServer.2014.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
Filegroups	Microsoft.SQLServer.2014.DBFileGroup.StateView	Microsoft.SQLServer.2014.FileGroup	Microsoft.SystemCenter.StateViewType	Public	True
Computers	Microsoft.SQLServer.2014.Server.StateView	Microsoft.Windows.Computer	Microsoft.SystemCenter.StateViewType	Public	True
Active Alerts	Microsoft.SQLServer.2014.ServerRole.ActiveAlertsView	Microsoft.SQLServer.2014.AlertsScopeGroupL3	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.2014.ServerRole.AllPerformanceDataView	Microsoft.SQLServer.2014.ServerRole	Microsoft.SystemCenter.PerformanceViewType	Public	True
Task Status	Microsoft.SQLServer.2014.ServerRole.TaskStatusView	Microsoft.SQLServer.2014.ServerRole	Microsoft.SystemCenter.TaskStatusViewType	Public	True
Memory-Optimized Data Filegroup Containers	Microsoft.SQLServer.2014.View.Container.State	Microsoft.SQLServer.2014.Container	Microsoft.SystemCenter.StateViewType	Public	True
Memory-Optimized Data Filegroups	Microsoft.SQLServer.2014.View.DBFileGroupFx.State	Microsoft.SQLServer.2014.DBFileGroupFx	Microsoft.SystemCenter.StateViewType	Public	True
Active Alerts	Microsoft.SQLServer.2014.View.InMemoryOLTP.Alerts	Microsoft.SQLServer.2014.InMemoryOLTPScopeGroup	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceData	Microsoft.SQLServer.2014.InMemoryOLTPScopeGroup	Microsoft.SystemCenter.PerformanceViewType	Public	True
Resource Pools	Microsoft.SQLServer.2014.View.UserResourcePool.State	Microsoft.SQLServer.2014.UserResourcePool	Microsoft.SystemCenter.StateViewType	Public	True