Microsoft SQL Server 2016 (Discovery)

Microsoft.SQLServer.2016.Discovery :: 6.7.7.0 (Management Pack)

This Management Pack discovers Microsoft SQL Server 2016 and related objects. The management pack only contains the discovery logic and requires the separate monitoring management pack to be imported to monitor the discovered objects.

• Show Management Pack XML
• Get Management Pack data in Excel format
• Download: Microsoft.SQLServer.2016.Discovery.mp

Management Pack Elements

Classes (34)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	SQL Server 2016 Agent	Microsoft.SQLServer.2016.Agent	Microsoft.SQLServer.2016.Component	False	True	False	False	False	Public
	SQL Server 2016 Agent Group	Microsoft.SQLServer.2016.AgentGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 Agent Job	Microsoft.SQLServer.2016.AgentJob	Microsoft.SQLServer.2016.Component	False	True	False	False	False	Public
	SQL Server 2016 Component	Microsoft.SQLServer.2016.Component	Microsoft.Windows.ApplicationComponent	True	False	False	False	False	Public
	SQL Server 2016 Components	Microsoft.SQLServer.2016.ComponentsGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 Computers	Microsoft.SQLServer.2016.ComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
	SQL Server 2016 DB Memory-Optimized Data Container	Microsoft.SQLServer.2016.Container	Microsoft.SQLServer.2016.Component	False	True	False	False	False	Public
	SQL Server 2016 DB	Microsoft.SQLServer.2016.Database	System.Database	False	True	False	False	False	Public
	SQL Server 2016 Database Critical Policy	Microsoft.SQLServer.2016.DatabaseErrorUserPolicy	Microsoft.SQLServer.2016.Policy	False	True	False	False	False	Public
	SQL Server 2016 Database Group	Microsoft.SQLServer.2016.DatabaseGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 Database Warning Policy	Microsoft.SQLServer.2016.DatabaseWarningUserPolicy	Microsoft.SQLServer.2016.Policy	False	True	False	False	False	Public
	SQL Server 2016 DB Engine	Microsoft.SQLServer.2016.DBEngine	Microsoft.SQLServer.2016.ServerRole	False	True	False	False	False	Public
	SQL Server 2016 DB File	Microsoft.SQLServer.2016.DBFile	Microsoft.SQLServer.2016.File	False	True	False	False	False	Public
	SQL Server 2016 DB Filegroup	Microsoft.SQLServer.2016.DBFileGroup	Microsoft.SQLServer.2016.FileGroup	False	True	False	False	False	Public
	SQL Server 2016 DB FILESTREAM Filegroup	Microsoft.SQLServer.2016.DBFileGroupFd	Microsoft.SQLServer.2016.FileGroup	False	True	False	False	False	Public
	SQL Server 2016 DB Memory-Optimized Data Filegroup	Microsoft.SQLServer.2016.DBFileGroupFx	Microsoft.SQLServer.2016.FileGroup	False	True	False	False	False	Public
	SQL Server 2016 DB Log File	Microsoft.SQLServer.2016.DBLogFile	Microsoft.SQLServer.2016.File	False	True	False	False	False	Public
	SQL Server 2016 DB Perspective	Microsoft.SQLServer.2016.DBPerspective	System.Perspective	True	True	False	False	False	Public
	SQL Server 2016 Default Resource Pool	Microsoft.SQLServer.2016.DefaultPool	Microsoft.SQLServer.2016.UserResourcePool	False	True	False	False	False	Public
	SQL Server 2016 Event Log Collection Target	Microsoft.SQLServer.2016.EventLogCollectionTarget	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public
	SQL Server Express 2016 DB Engine Group	Microsoft.SQLServer.2016.ExpressInstancesGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 File	Microsoft.SQLServer.2016.File	Microsoft.SQLServer.2016.Component	True	False	False	False	False	Public
	SQL Server 2016 Filegroup Abstract	Microsoft.SQLServer.2016.FileGroup	Microsoft.SQLServer.2016.Component	True	False	False	False	False	Public
	SQL Server 2016 Memory-Optimized Data Instances Group	Microsoft.SQLServer.2016.InMemoryOLTPInstancesGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 Memory-Optimized Data Scope Group	Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 DB Engine Group	Microsoft.SQLServer.2016.InstanceGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2016 Internal Resource Pool	Microsoft.SQLServer.2016.InternalPool	Microsoft.SQLServer.2016.ResourcePool	False	True	False	False	False	Public
	SQL Server 2016 Custom User Policy	Microsoft.SQLServer.2016.Policy	Microsoft.SQLServer.2016.Component	True	False	False	False	False	Public
	SQL Server 2016 Resource Pool	Microsoft.SQLServer.2016.ResourcePool	Microsoft.SQLServer.2016.Component	True	True	False	False	False	Public
	SQL Server 2016 Resource Pool Group	Microsoft.SQLServer.2016.ResourcePoolGroup	System.Group	False	True	False	True	False	Public
	SQL Server 2016 Installation Seed	Microsoft.SQLServer.2016.Seed	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public
	SQL Server 2016 Role	Microsoft.SQLServer.2016.ServerRole	Microsoft.Windows.ComputerRole	True	True	False	False	False	Public
	SQL Server 2016 User-Defined Resource Pools	Microsoft.SQLServer.2016.UserDefinedPool	Microsoft.SQLServer.2016.UserResourcePool	False	True	False	False	False	Public
	SQL Server 2016 User Resource Pool	Microsoft.SQLServer.2016.UserResourcePool	Microsoft.SQLServer.2016.ResourcePool	True	True	False	False	False	Public

Relationship Types (26)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	MSSQL 2016: SQL Server 2016 Agent Group Contains Agents	Microsoft.SQLServer.2016.AgentGroupContainsAgent	Microsoft.SQLServer.2016.AgentGroup	Microsoft.SQLServer.2016.Agent	Public	False
	MSSQL 2016: SQL Server 2016 Agent Hosts Agent Job	Microsoft.SQLServer.2016.AgentHostsAgentJob	Microsoft.SQLServer.2016.Agent	Microsoft.SQLServer.2016.AgentJob	Public	False
	MSSQL 2016: Components Group Contains All SQL Server 2016 related components	Microsoft.SQLServer.2016.ComponentsGroupContainsEntity	Microsoft.SQLServer.2016.ComponentsGroup	System.Entity	Public	False
	MSSQL 2016: SQL Server 2016 Database Group Contains Databases	Microsoft.SQLServer.2016.DatabaseGroupContainsDatabase	Microsoft.SQLServer.2016.DatabaseGroup	Microsoft.SQLServer.2016.Database	Public	False
	MSSQL 2016: SQL Server 2016 Database hosts Critical User Policy	Microsoft.SQLServer.2016.DatabaseHostsDBErrorUserPolicy	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DatabaseErrorUserPolicy	Public	False
	MSSQL 2016: SQL Server 2016 Database hosts Warning User Policy	Microsoft.SQLServer.2016.DatabaseHostsDBWarningUserPolicy	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DatabaseWarningUserPolicy	Public	False
	MSSQL 2016: SQL Server 2016 Database Engine Hosts SQL Database	Microsoft.SQLServer.2016.DBEngineHostsDatabase	Microsoft.SQLServer.2016.DBEngine	Microsoft.SQLServer.2016.Database	Public	False
	MSSQL 2016: SQL Server 2016 Database Engine Hosts Resource Pool Group	Microsoft.SQLServer.2016.DBEngineHostsResourcePoolGroup	Microsoft.SQLServer.2016.DBEngine	Microsoft.SQLServer.2016.ResourcePoolGroup	Public	False
	MSSQL 2016: SQL Server 2016 Database Engine Hosts SQL Server 2016 Agent	Microsoft.SQLServer.2016.DBEngineHostsSQLAgent	Microsoft.SQLServer.2016.DBEngine	Microsoft.SQLServer.2016.Agent	Public	False
	MSSQL 2016: SQL Server 2016 Memory-Optimized Data Filegroup Hosts Container	Microsoft.SQLServer.2016.DBFileGroupFxHostsContainer	Microsoft.SQLServer.2016.DBFileGroupFx	Microsoft.SQLServer.2016.Container	Public	False
	MSSQL 2016: SQL Server 2016 Filegroup Hosts File	Microsoft.SQLServer.2016.DBFileGroupHostsDBFile	Microsoft.SQLServer.2016.DBFileGroup	Microsoft.SQLServer.2016.DBFile	Public	False
	MSSQL 2016: SQL Server 2016 Database File Runs on Logical Disk	Microsoft.SQLServer.2016.DBFileToLogicalDisk	Microsoft.SQLServer.2016.DBFile	Microsoft.Windows.LogicalDisk	Public	False
	MSSQL 2016: SQL Server 2016 Database Hosts Filegroup	Microsoft.SQLServer.2016.DBHostsFileGroup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DBFileGroup	Public	False
	MSSQL 2016: SQL Server 2016 Database Hosts Log File	Microsoft.SQLServer.2016.DBHostsLogFile	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DBLogFile	Public	False
	MSSQL 2016: SQL Server Express 2016 Instance Group Contains Instances	Microsoft.SQLServer.2016.ExpressInstancesGroupContainsDBEngine	Microsoft.SQLServer.2016.ExpressInstancesGroup	Microsoft.SQLServer.2016.DBEngine	Public	False
	MSSQL 2016: SQL Server 2016 Memory-Optimized Data Instances Group Contains Instances	Microsoft.SQLServer.2016.InMemoryOLTPInstancesGroupContainsDBEngine	Microsoft.SQLServer.2016.InMemoryOLTPInstancesGroup	Microsoft.SQLServer.2016.DBEngine	Public	False
	MSSQL 2016: SQL Server 2016 Instance Group Contains Instances	Microsoft.SQLServer.2016.InstanceGroupContainsDBEngine	Microsoft.SQLServer.2016.InstanceGroup	Microsoft.SQLServer.2016.DBEngine	Public	False
	Server Computer Hosts SQL Server 2016 Event Log Collection Target	Microsoft.SQLServer.2016.Relationship.ServerComputerHostsEventLogCollectionTarget	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.2016.EventLogCollectionTarget	Public	False
	MSSQL 2016: Memory-Optimized Data Scope Group Contains Database Memory-Optimized Data Filegroup	Microsoft.SQLServer.2016.Relationships.InMemoryOLTPScopeGroupContainsDBFileGroupFx	Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup	Microsoft.SQLServer.2016.DBFileGroupFx	Internal	False
	MSSQL 2016: Memory-Optimized Data Scope Group Contains Resource Pool	Microsoft.SQLServer.2016.Relationships.InMemoryOLTPScopeGroupContainsResourcePool	Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup	Microsoft.SQLServer.2016.UserResourcePool	Internal	False
	MSSQL 2016: Database References User Recource Pool	Microsoft.SQLServer.2016.RelationshipType.DatabaseReferencesUserResourcePool	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.UserResourcePool	Public	False
	MSSQL 2016: SQL Server 2016 Database Hosts FILESTREAM Filegroup	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFd	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DBFileGroupFd	Public	False
	MSSQL 2016: SQL Server 2016 Database Hosts Memory-Optimized Data Filegroup	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DBFileGroupFx	Public	False
	MSSQL 2016: Resource Pool Group Hosts Resource Pools	Microsoft.SQLServer.2016.ResourcePoolGroupHostsResourcePool	Microsoft.SQLServer.2016.ResourcePoolGroup	Microsoft.SQLServer.2016.ResourcePool	Public	False
	MSSQL 2016: Server Computer Hosts SQL Server 2016 Installation Seed	Microsoft.SQLServer.2016.ServerComputerHostsSeed	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.2016.Seed	Public	False
	MSSQL 2016: Windows Computer Hosts Database Perspective	Microsoft.SQLServer.2016.WindowsComputerHostsDBPerspective	Microsoft.Windows.Computer	Microsoft.SQLServer.2016.DBPerspective	Public	False

DataSource Modules (7)

	DisplayName	ID	Isolation	Accessibility
	SQL Server Agent Job Discovery	Microsoft.SQLServer.2016.AgentJobDiscovery	Any	Internal
	Data Source Database Engine Resource Pools	Microsoft.SQLServer.2016.DataSource.ResourcePool	Any	Internal
	SQL Server 2016 Database Discovery	Microsoft.SQLServer.2016.DBDiscovery	Any	Internal
	SQL Server 2016 DB Engine Discovery Source	Microsoft.SQLServer.2016.DBEngineDiscovery	Any	Internal
	SQL Server 2016 Database Filegroup Discovery	Microsoft.SQLServer.2016.DBFileGroupDiscovery	Any	Internal
	SQL Server 2016 Database File Discovery	Microsoft.SQLServer.2016.DBFilesDiscovery	Any	Internal
	User Policy Discovery Data Source	Microsoft.SQLServer.2016.DBUserPolicyDiscovery	Any	Internal

ProbeAction Modules (3)

	DisplayName	ID	Isolation	Accessibility
	DB Filegroup Script Probe Discovery	Microsoft.SQLServer.2016.DBFileGroupScriptProbeDiscovery	Any	Internal
	DB Files Script Probe Discovery	Microsoft.SQLServer.2016.DBFilesScriptProbeDiscovery	Any	Internal
	User Policy Script Probe Discovery	Microsoft.SQLServer.2016.DBUserPolicyScriptProbeDiscovery	Any	Internal

Discoveries (23)

	DisplayName	ID	Target	Enabled
	MSSQL 2016: Discover SQL Server Agent for a DB Engine	Microsoft.SQLServer.2016.AgentDiscovery	Microsoft.SQLServer.2016.DBEngine	True
	MSSQL 2016: Populate SQL Server 2016 Agent Group	Microsoft.SQLServer.2016.AgentGroupDiscovery	Microsoft.SQLServer.2016.AgentGroup	True
	MSSQL 2016: Discover SQL Server 2016 Agent Jobs	Microsoft.SQLServer.2016.AgentJobDiscoveryRule	Microsoft.SQLServer.2016.Agent	False
	MSSQL 2016: Populate SQL Server 2016 Components Group	Microsoft.SQLServer.2016.ComponentsGroupDiscovery	Microsoft.SQLServer.2016.ComponentsGroup	True
	MSSQL 2016: Populate SQL Server 2016 Computer Group	Microsoft.SQLServer.2016.ComputerGroupDiscovery	Microsoft.SQLServer.2016.ComputerGroup	True
	MSSQL 2016: Discover Databases for a Database Engine	Microsoft.SQLServer.2016.DatabaseDiscoveryRule	Microsoft.SQLServer.2016.DBEngine	True
	MSSQL 2016: Populate SQL Server 2016 Database Group	Microsoft.SQLServer.2016.DatabaseGroupDiscovery	Microsoft.SQLServer.2016.DatabaseGroup	True
	MSSQL 2016: Database Custom User Policy Discovery	Microsoft.SQLServer.2016.DatabaseUserPolicyDiscoveryRule	Microsoft.SQLServer.2016.DBEngine	False
	MSSQL 2016: Discover SQL Server 2016 Database Engines	Microsoft.SQLServer.2016.DBEngineDiscoveryRule.Server	Microsoft.SQLServer.2016.Seed	True
	MSSQL 2016: Discover Filegroups	Microsoft.SQLServer.2016.DBFileGroupDiscoveryRule	Microsoft.SQLServer.2016.DBEngine	True
	MSSQL 2016: Discover Memory-Optimized Data Filegroup Containers	Microsoft.SQLServer.2016.Discovery.Container	Microsoft.SQLServer.2016.DBEngine	False
	MSSQL 2016: Discover Data Files	Microsoft.SQLServer.2016.Discovery.DBFile	Microsoft.SQLServer.2016.DBEngine	True
	MSSQL 2016: Discover Memory-Optimized Data Filegroup	Microsoft.SQLServer.2016.Discovery.DBFileGroupFx	Microsoft.SQLServer.2016.DBEngine	False
	MSSQL 2016: Discover Transaction Log File	Microsoft.SQLServer.2016.Discovery.DBLogFile	Microsoft.SQLServer.2016.DBEngine	True
	SQL Server 2016 Event Log Collection Target Discovery	Microsoft.SQLServer.2016.Discovery.EventLogCollectionTarget	Microsoft.SQLServer.2016.Seed	True
	MSSQL 2016: Memory-Optimized Data Scope Group Discovery	Microsoft.SQLServer.2016.Discovery.InMemoryOLTPScopeGroup	Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup	True
	MSSQL 2016: Discover Database Engine Resource Pools	Microsoft.SQLServer.2016.Discovery.ResourcePool	Microsoft.SQLServer.2016.Database	True
	MSSQL 2016: Populate SQL Server Express 2016 Instance Group	Microsoft.SQLServer.2016.ExpressInstancesGroupContainsDBEngine.Discovery	Microsoft.SQLServer.2016.ExpressInstancesGroup	True
	MSSQL 2016: Populate SQL Server 2016 Memory-Optimized Data Instances Group	Microsoft.SQLServer.2016.InMemoryOLTPInstancesGroupContainsDBEngine.Discovery	Microsoft.SQLServer.2016.InMemoryOLTPInstancesGroup	True
	MSSQL 2016: Populate SQL Server 2016 Instance Group	Microsoft.SQLServer.2016.InstanceGroupDiscovery	Microsoft.SQLServer.2016.InstanceGroup	True
	MSSQL 2016: Populate Microsoft SQL Server 2016 Computer Group	Microsoft.SQLServer.2016.PopulateSQLServersComputerGroup	Microsoft.SQLServer.2016.ComputerGroup	True
	MSSQL 2016: Populate Microsoft SQL Server 2016 Instance Group	Microsoft.SQLServer.2016.PopulateSQLServersInstanceGroup	Microsoft.SQLServer.2016.InstanceGroup	True
	MSSQL 2016: Discover SQL Server 2016 DB Installation Source (seed)	Microsoft.SQLServer.2016.SeedDiscovery	Microsoft.Windows.Server.Computer	True

Rules (2)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MSSQL 2016: Discovery failed	Microsoft.SQLServer.2016.DiscoveryFailed.Rule	Microsoft.SQLServer.2016.EventLogCollectionTarget	Alert	True	True
	MSSQL 2016: Discovery warning	Microsoft.SQLServer.2016.DiscoveryWarning.Rule	Microsoft.SQLServer.2016.EventLogCollectionTarget	Alert	True	True

Image References (9)

	DisplayName	ID	ImageID
	SQL Server 2016 DB Memory-Optimized Data Container	Microsoft.SQLServer.2016.Container	Microsoft.SQLServer.2016.Container.Image64
	SQL Server 2016 DB	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.Database.Image80
	SQL Server 2016 DB Engine	Microsoft.SQLServer.2016.DBEngine	Microsoft.SQLServer.2016.DBEngine.Image.80
	SQL Server 2016 DB File	Microsoft.SQLServer.2016.DBFile	Microsoft.SQLServer.2016.DBFile.Image64
	SQL Server 2016 DB Memory-Optimized Data Filegroup	Microsoft.SQLServer.2016.DBFileGroupFx	Microsoft.SQLServer.2016.DBFileGroupFx.Image64
	SQL Server 2016 DB Log File	Microsoft.SQLServer.2016.DBLogFile	Microsoft.SQLServer.2016.DBLogFile.Image64
	SQL Server 2016 Filegroup Abstract	Microsoft.SQLServer.2016.FileGroup	Microsoft.SQLServer.2016.FileGroup.Image64
	SQL Server 2016 Custom User Policy	Microsoft.SQLServer.2016.Policy	Microsoft.SQLServer.2016.Policy.Image80
	SQL Server 2016 Resource Pool	Microsoft.SQLServer.2016.ResourcePool	Microsoft.SQLServer.2016.ResourcePool.Image64

Images (20)

	ID	File Name	Accessibility
	Microsoft.SQLServer.2016.Container.Image16	Microsoft.SQLServer.2016.Container.Image16.png	Public
	Microsoft.SQLServer.2016.Container.Image64	Microsoft.SQLServer.2016.Container.Image64.png	Public
	Microsoft.SQLServer.2016.Database.Image16	Microsoft.SQLServer.2016.Database.Image16.png	Public
	Microsoft.SQLServer.2016.Database.Image80	Microsoft.SQLServer.2016.Database.Image80.png	Public
	Microsoft.SQLServer.2016.DBEngine.Image.80	Microsoft.SQLServer.2016.DBEngine.Image.80.png	Public
	Microsoft.SQLServer.2016.DBEngine.Image16	Microsoft.SQLServer.2016.DBEngine.Image16.png	Public
	Microsoft.SQLServer.2016.DBFile.Image16	Microsoft.SQLServer.2016.DBFile.Image16.png	Public
	Microsoft.SQLServer.2016.DBFile.Image64	Microsoft.SQLServer.2016.DBFile.Image64.png	Public
	Microsoft.SQLServer.2016.DBFileGroupFx.Image16	Microsoft.SQLServer.2016.DBFileGroupFx.Image16.png	Public
	Microsoft.SQLServer.2016.DBFileGroupFx.Image64	Microsoft.SQLServer.2016.DBFileGroupFx.Image64.png	Public
	Microsoft.SQLServer.2016.DBLogFile.Image16	Microsoft.SQLServer.2016.DBLogFile.Image16.png	Public
	Microsoft.SQLServer.2016.DBLogFile.Image64	Microsoft.SQLServer.2016.DBLogFile.Image64.png	Public
	Microsoft.SQLServer.2016.FileGroup.Image16	Microsoft.SQLServer.2016.FileGroup.Image16.png	Public
	Microsoft.SQLServer.2016.FileGroup.Image64	Microsoft.SQLServer.2016.FileGroup.Image64.png	Public
	Microsoft.SQLServer.2016.Policy.Image16	Microsoft.SQLServer.2016.Policy.Image16.png	Public
	Microsoft.SQLServer.2016.Policy.Image80	Microsoft.SQLServer.2016.Policy.Image80.png	Public
	Microsoft.SQLServer.2016.ResourcePool.Image16	Microsoft.SQLServer.2016.ResourcePool.Image16.png	Public
	Microsoft.SQLServer.2016.ResourcePool.Image64	Microsoft.SQLServer.2016.ResourcePool.Image64.png	Public
	Microsoft.SQLServer.2016.SystemDatabase.Image16	Microsoft.SQLServer.2016.SystemDatabase.Image16.png	Public
	Microsoft.SQLServer.2016.SystemDatabase.Image80	Microsoft.SQLServer.2016.SystemDatabase.Image80.png	Public