Microsoft SQL Server on Windows (Discovery)

Microsoft.SQLServer.Windows.Discovery :: 7.0.15.0 (Management Pack)

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

Summary

Microsoft SQL Server on Windows (Discovery) Management Pack discovers Microsoft SQL Server and related objects on Windows. It requires Microsoft SQL Server Core Library Management Pack. The management pack only contains the discovery logic and requires the separate monitoring management pack to be imported to monitor the discovered objects.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (47)
RelationshipType (36)

ModuleTypes

DataSourceModuleType (25)
ProbeActionModuleType (9)
WriteActionModuleType (1)

Monitoring

Discovery (26)
Rule (3)
Overrides

DiscoveryPropertyOverride (5)

Presentation

ImageReference (2)

Resources

DeployableAssembly (13)

Classes (47)

System.Entity

System.ConfigItem

System.LogicalEntity

System.ApplicationComponent

System.Database

Microsoft.SQLServer.Core.Agent

Microsoft.SQLServer.Windows.Agent

Microsoft.SQLServer.Windows.LocalAgent

Microsoft.SQLServer.Core.AgentJob

Microsoft.SQLServer.Windows.AgentJob

Microsoft.SQLServer.Windows.LocalAgentJob

Microsoft.SQLServer.Core.Database

Microsoft.SQLServer.Windows.Database

Microsoft.SQLServer.Windows.LocalDatabase

Microsoft.Windows.ApplicationComponent

Microsoft.SQLServer.Core.MonitoringPoolAlertCollection

Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection

Microsoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeed
Microsoft.SQLServer.Windows.LocalDiscoverySeed

System.Group

Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup

Microsoft.SQLServer.Core.AlwaysOnPolicy

Microsoft.SQLServer.Windows.AlwaysOnPolicy

Microsoft.SQLServer.Core.AlwaysOnSeed

Microsoft.SQLServer.Windows.AlwaysOnSeed

Microsoft.SQLServer.Core.AvailabilityDatabaseHealth

Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth

Microsoft.SQLServer.Core.AvailabilityGroupHealth

Microsoft.SQLServer.Windows.AvailabilityGroupHealth

Microsoft.SQLServer.Core.AvailabilityReplica

Microsoft.SQLServer.Windows.AvailabilityReplica

Microsoft.SQLServer.Core.File

Microsoft.SQLServer.Core.Container

Microsoft.SQLServer.Windows.Container

Microsoft.SQLServer.Core.DBFile

Microsoft.SQLServer.Windows.DBFile

Microsoft.SQLServer.Core.DBLogFile

Microsoft.SQLServer.Windows.DBLogFile

Microsoft.SQLServer.Core.DatabaseReplica

Microsoft.SQLServer.Windows.DatabaseReplica

Microsoft.SQLServer.Core.DBEngine

Microsoft.SQLServer.Windows.DBEngine

Microsoft.SQLServer.Windows.LocalDBEngine

Microsoft.SQLServer.Core.Filegroup

Microsoft.SQLServer.Core.DBFilegroup

Microsoft.SQLServer.Windows.DBFilegroup

Microsoft.SQLServer.Core.DBFilegroupFd

Microsoft.SQLServer.Windows.DBFilegroupFd

Microsoft.SQLServer.Core.DBFilegroupFx

Microsoft.SQLServer.Windows.DBFilegroupFx

Microsoft.SQLServer.Core.Policy

Microsoft.SQLServer.Windows.Policy

Microsoft.SQLServer.Core.ResourcePool

Microsoft.SQLServer.Windows.ResourcePool

Microsoft.SQLServer.Windows.DBEngineSeed
Microsoft.SQLServer.Windows.ResourcePoolGroup

DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
MSSQL on Windows: Agent	Microsoft.SQLServer.Windows.Agent	Microsoft.SQLServer.Core.Agent	False	True	False	False	False	Public
MSSQL on Windows: Agent Job	Microsoft.SQLServer.Windows.AgentJob	Microsoft.SQLServer.Core.AgentJob	False	True	False	False	False	Public
MSSQL on Windows: Always On Custom User Policy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	Microsoft.SQLServer.Core.AlwaysOnPolicy	True	False	False	False	False	Public
MSSQL on Windows: Always On Seed	Microsoft.SQLServer.Windows.AlwaysOnSeed	Microsoft.SQLServer.Core.AlwaysOnSeed	False	True	False	False	False	Public
SQL Server Availability Database Health	Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth	Microsoft.SQLServer.Core.AvailabilityDatabaseHealth	False	True	False	False	False	Public
MSSQL on Windows: Availability Group Critical Policy	Microsoft.SQLServer.Windows.AvailabilityGroupErrorUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: Availability Group Health	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Microsoft.SQLServer.Core.AvailabilityGroupHealth	False	True	False	False	False	Public
MSSQL on Windows: Availability Group Warning Policy	Microsoft.SQLServer.Windows.AvailabilityGroupWarningUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: Availability Replica	Microsoft.SQLServer.Windows.AvailabilityReplica	Microsoft.SQLServer.Core.AvailabilityReplica	False	True	False	False	False	Public
MSSQL on Windows: Availability Replica Critical Policy	Microsoft.SQLServer.Windows.AvailabilityReplicaErrorUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: Availability Replica Warning Policy	Microsoft.SQLServer.Windows.AvailabilityReplicaWarningUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: SQL Server Computers	Microsoft.SQLServer.Windows.ComputersGroup	System.Group	False	False	True	True	False	Public
MSSQL on Windows: DB Memory-Optimized Data Container	Microsoft.SQLServer.Windows.Container	Microsoft.SQLServer.Core.Container	False	True	False	False	False	Public
MSSQL on Windows: Database	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Core.Database	False	True	False	False	False	Public
MSSQL on Windows: Database Critical Policy	Microsoft.SQLServer.Windows.DatabaseErrorUserPolicy	Microsoft.SQLServer.Windows.Policy	False	True	False	False	False	Public
MSSQL on Windows: Database Replica	Microsoft.SQLServer.Windows.DatabaseReplica	Microsoft.SQLServer.Core.DatabaseReplica	False	True	False	False	False	Public
MSSQL on Windows: Database Replica Critical Policy	Microsoft.SQLServer.Windows.DatabaseReplicaErrorUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: Database Replica Warning Policy	Microsoft.SQLServer.Windows.DatabaseReplicaWarningUserPolicy	Microsoft.SQLServer.Windows.AlwaysOnPolicy	False	True	False	False	False	Public
MSSQL on Windows: Database Warning Policy	Microsoft.SQLServer.Windows.DatabaseWarningUserPolicy	Microsoft.SQLServer.Windows.Policy	False	True	False	False	False	Public
MSSQL on Windows: DB Engine	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Core.DBEngine	False	False	False	False	False	Public
MSSQL on Windows: SQL Server Express DB Engine Group	Microsoft.SQLServer.Windows.DBEngineExpressGroup	System.Group	False	False	True	True	False	Public
MSSQL on Windows: DB Engine Group	Microsoft.SQLServer.Windows.DBEngineGroup	System.Group	False	False	True	True	False	Public
MSSQL on Windows: DB Engine Seed	Microsoft.SQLServer.Windows.DBEngineSeed	System.Entity	False	False	False	False	False	Public
MSSQL on Windows: DB File	Microsoft.SQLServer.Windows.DBFile	Microsoft.SQLServer.Core.DBFile	False	True	False	False	False	Public
MSSQL on Windows: DB Filegroup	Microsoft.SQLServer.Windows.DBFilegroup	Microsoft.SQLServer.Core.DBFilegroup	False	True	False	False	False	Public
MSSQL on Windows: DB FILESTREAM Filegroup	Microsoft.SQLServer.Windows.DBFilegroupFd	Microsoft.SQLServer.Core.DBFilegroupFd	False	True	False	False	False	Public
MSSQL on Windows: DB Memory-Optimized Data Filegroup	Microsoft.SQLServer.Windows.DBFilegroupFx	Microsoft.SQLServer.Core.DBFilegroupFx	False	True	False	False	False	Public
MSSQL on Windows: DB Log File	Microsoft.SQLServer.Windows.DBLogFile	Microsoft.SQLServer.Core.DBLogFile	False	True	False	False	False	Public
MSSQL on Windows: Default Resource Pool	Microsoft.SQLServer.Windows.DefaultPool	Microsoft.SQLServer.Windows.UserResourcePool	False	True	False	False	False	Public
MSSQL on Windows: In-Memory OLTP Feature Group	Microsoft.SQLServer.Windows.Discovery.InMemoryOltpFeatureGroup	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	False	False	True	False	False	Public
MSSQL on Windows: SmartAdmin Feature Group	Microsoft.SQLServer.Windows.Discovery.SmartAdminFeatureGroup	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	False	False	True	False	False	Public
MSSQL on Windows: Agent Feature Group	Microsoft.SQLServer.Windows.Discovery.SqlAgentFeatureGroup	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	False	False	True	False	False	Public
MSSQL on Windows: Abstract Feature Group	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	System.Group	True	False	False	True	False	Public
MSSQL on Windows: Resource Pool Feature Group	Microsoft.SQLServer.Windows.Discovery.SqlResurcePoolFeatureGroup	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	False	False	True	False	False	Public
MSSQL on Windows: Internal Resource Pool	Microsoft.SQLServer.Windows.InternalPool	Microsoft.SQLServer.Windows.ResourcePool	False	True	False	False	False	Public
MSSQL on Windows: Local Agent	Microsoft.SQLServer.Windows.LocalAgent	Microsoft.SQLServer.Windows.Agent	False	True	False	False	False	Public
MSSQL on Windows: Local Agent Job	Microsoft.SQLServer.Windows.LocalAgentJob	Microsoft.SQLServer.Windows.AgentJob	False	True	False	False	False	Public
MSSQL on Windows: Local Clustered DB Engine Seed	Microsoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeed	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public
MSSQL on Windows: Local DB	Microsoft.SQLServer.Windows.LocalDatabase	Microsoft.SQLServer.Windows.Database	False	True	False	False	False	Public
MSSQL on Windows: Local DB Engine	Microsoft.SQLServer.Windows.LocalDBEngine	Microsoft.SQLServer.Windows.DBEngine	False	False	False	False	False	Public
MSSQL on Windows: Local Discovery Seed	Microsoft.SQLServer.Windows.LocalDiscoverySeed	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public
MSSQL on Windows: Monitoring Pool Alert Collection	Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection	Microsoft.SQLServer.Core.MonitoringPoolAlertCollection	False	True	False	False	False	Public
MSSQL on Windows: Custom User Policy	Microsoft.SQLServer.Windows.Policy	Microsoft.SQLServer.Core.Policy	True	False	False	False	False	Public
MSSQL on Windows: Resource Pool	Microsoft.SQLServer.Windows.ResourcePool	Microsoft.SQLServer.Core.ResourcePool	True	True	False	False	False	Public
MSSQL on Windows: Resource Pool Group	Microsoft.SQLServer.Windows.ResourcePoolGroup	System.Entity	False	True	False	False	False	Public
MSSQL on Windows: User-Defined Resource Pool	Microsoft.SQLServer.Windows.UserDefinedPool	Microsoft.SQLServer.Windows.UserResourcePool	False	True	False	False	False	Public
MSSQL on Windows: User Resource Pool	Microsoft.SQLServer.Windows.UserResourcePool	Microsoft.SQLServer.Windows.ResourcePool	True	True	False	False	False	Public

Relationship Types (36)

DisplayName	ID	Source	Target	Accessibility	Abstract
MSSQL on Windows: Agent Hosts SQL Server Agent Job	Microsoft.SQLServer.Windows.AgentHostsAgentJob	Microsoft.SQLServer.Windows.Agent	Microsoft.SQLServer.Windows.AgentJob	Public	False
MSSQL on Windows: Availability Database Contains Database Replica	Microsoft.SQLServer.Windows.AvailabilityDatabaseContainsDatabaseReplica	Microsoft.SQLServer.Core.AvailabilityDatabase	Microsoft.SQLServer.Windows.DatabaseReplica	Public	False
MSSQL on Windows: Availability Database References Availability Database Health	Microsoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth	Microsoft.SQLServer.Core.AvailabilityDatabase	Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth	Public	False
MSSQL on Windows: Availability Group Health Hosts Availability Database Health	Microsoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityDatabaseHealth	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth	Public	False
MSSQL on Windows: Availability Group Health Hosts Availability Group Critical Policy	Microsoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupErrorUserPolicy	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Microsoft.SQLServer.Windows.AvailabilityGroupErrorUserPolicy	Public	False
MSSQL on Windows: Availability Group Health Hosts Availability Group Warning Policy	Microsoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupWarningUserPolicy	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Microsoft.SQLServer.Windows.AvailabilityGroupWarningUserPolicy	Public	False
MSSQL on Windows: Availability Group references SQL Server Availability Group Health	Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth	Microsoft.SQLServer.Core.AvailabilityGroup	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Public	False
MSSQL on Windows: Availability Replica Hosts Availability Replica Critical Policy	Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy	Microsoft.SQLServer.Windows.AvailabilityReplica	Microsoft.SQLServer.Windows.AvailabilityReplicaErrorUserPolicy	Public	False
MSSQL on Windows: Availability Replica Hosts Availability Replica Warning Policy	Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy	Microsoft.SQLServer.Windows.AvailabilityReplica	Microsoft.SQLServer.Windows.AvailabilityReplicaWarningUserPolicy	Public	False
MSSQL on Windows: Availability Replica Hosts Database Replica	Microsoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplica	Microsoft.SQLServer.Windows.AvailabilityReplica	Microsoft.SQLServer.Windows.DatabaseReplica	Public	False
MSSQL on Windows: Computers Contains Windows Computer	Microsoft.SQLServer.Windows.ComputersGroupContainsWindowsComputer	Microsoft.SQLServer.Windows.ComputersGroup	Microsoft.Windows.Computer	Public	False
MSSQL on Windows: DB Hosts SQL Server Database Critical Policy	Microsoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicy	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DatabaseErrorUserPolicy	Public	False
MSSQL on Windows: DB Hosts SQL Server DB Filegroup	Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroup	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DBFilegroup	Public	False
MSSQL on Windows: DB Hosts SQL Server DB FILESTREAM Filegroup	Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFd	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DBFilegroupFd	Public	False
MSSQL on Windows: DB Hosts SQL Server DB Memory-Optimized Data Filegroup	Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFx	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DBFilegroupFx	Public	False
MSSQL on Windows: DB Hosts SQL Server DB Log File	Microsoft.SQLServer.Windows.DatabaseHostsDBLogFile	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DBLogFile	Public	False
MSSQL on Windows: DB Hosts SQL Server Database Warning Policy	Microsoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicy	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.DatabaseWarningUserPolicy	Public	False
MSSQL on Windows: Database References User Resource Pool	Microsoft.SQLServer.Windows.DatabaseReferencesUserResourcePool	Microsoft.SQLServer.Windows.Database	Microsoft.SQLServer.Windows.UserResourcePool	Public	False
MSSQL on Windows: Database Replica Hosts Database Replica Critical Policy	Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy	Microsoft.SQLServer.Windows.DatabaseReplica	Microsoft.SQLServer.Windows.DatabaseReplicaErrorUserPolicy	Public	False
MSSQL on Windows: Database Replica Hosts Database Replica Warning Policy	Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy	Microsoft.SQLServer.Windows.DatabaseReplica	Microsoft.SQLServer.Windows.DatabaseReplicaWarningUserPolicy	Public	False
MSSQL on Windows: SQL Server Express DB Engine Group Contains SQL Server DB Engine	Microsoft.SQLServer.Windows.DBEngineExpressGroupContainsDBEngine	Microsoft.SQLServer.Windows.DBEngineExpressGroup	Microsoft.SQLServer.Windows.DBEngine	Public	False
MSSQL on Windows: DB Engine Group Contains SQL Server DB Engine	Microsoft.SQLServer.Windows.DBEngineGroupContainsDBEngine	Microsoft.SQLServer.Windows.DBEngineGroup	Microsoft.SQLServer.Windows.DBEngine	Public	False
MSSQL on Windows: DB Engine Hosts SQL Server Agent	Microsoft.SQLServer.Windows.DBEngineHostsAgent	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.Agent	Public	False
MSSQL on Windows: DB Engine Hosts Always On Seed	Microsoft.SQLServer.Windows.DBEngineHostsAlwaysOnSeed	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.AlwaysOnSeed	Public	False
MSSQL on Windows: DB Engine Hosts Availability Group Health	Microsoft.SQLServer.Windows.DBEngineHostsAvailabilityGroupHealth	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	Public	False
MSSQL on Windows: DB Engine Hosts Availability Replica	Microsoft.SQLServer.Windows.DBEngineHostsAvailabilityReplica	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.AvailabilityReplica	Public	False
MSSQL on Windows: DB Engine Hosts SQL Server DB	Microsoft.SQLServer.Windows.DBEngineHostsDatabase	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.Database	Public	False
MSSQL on Windows: DB Engine Hosts SQL Server Resource Pool Group	Microsoft.SQLServer.Windows.DBEngineHostsResourcePoolGroup	Microsoft.SQLServer.Windows.DBEngine	Microsoft.SQLServer.Windows.ResourcePoolGroup	Public	False
MSSQL on Windows: DB Engine Seed Contains SQL Server DB Engine	Microsoft.SQLServer.Windows.DBEngineSeedContainsDBEngine	Microsoft.SQLServer.Windows.DBEngineSeed	Microsoft.SQLServer.Windows.DBEngine	Public	False
MSSQL on Windows: DB Filegroup Hosts SQL Server DB Memory-Optimized Data Container	Microsoft.SQLServer.Windows.DBFilegroupFxHostsContainer	Microsoft.SQLServer.Windows.DBFilegroupFx	Microsoft.SQLServer.Windows.Container	Public	False
MSSQL on Windows: DB Filegroup Hosts SQL Server DB File	Microsoft.SQLServer.Windows.DBFilegroupHostsDBFile	Microsoft.SQLServer.Windows.DBFilegroup	Microsoft.SQLServer.Windows.DBFile	Public	False
SqlFeatureGroupContainsDBEngine Relationship	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroupContainsDBEngine	Microsoft.SQLServer.Windows.Discovery.SqlFeatureGroup	Microsoft.SQLServer.Windows.DBEngine	Internal	False
MSSQL on Windows: Resource Pool Group Hosts SQL Server Resource Pool	Microsoft.SQLServer.Windows.ResourcePoolGroupHostsResourcePool	Microsoft.SQLServer.Windows.ResourcePoolGroup	Microsoft.SQLServer.Windows.ResourcePool	Public	False
MSSQL on Windows: Server Computer Contains SQL Server DB Engine	Microsoft.SQLServer.Windows.ServerComputerContainsDBEngine	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.Windows.DBEngine	Public	False
MSSQL on Windows: Server Computer Hosts SQL Server Local Discovery Seed	Microsoft.SQLServer.Windows.ServerComputerHostsLocalClusteredDBEngineDiscoverySeed	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeed	Public	False
MSSQL on Windows: Server Computer Hosts SQL Server Local Discovery Seed	Microsoft.SQLServer.Windows.ServerComputerHostsLocalDiscoverySeed	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.Windows.LocalDiscoverySeed	Public	False

DataSource Modules (25)

DisplayName	ID	Isolation	Accessibility
MSSQL on Windows: Agent Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.AgentDiscovery	Any	Internal
MSSQL on Windows: Agent Job Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.AgentJobDiscovery	Any	Internal
MSSQL on Windows: Seed Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.AlwaysOnSeedDiscovery	Any	Internal
MSSQL on Windows: Availability Group Custom User Policy Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.AvailabilityGroupUserPolicyDiscovery	Any	Internal
MSSQL on Windows: Availability Replica Custom User Policy Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.AvailabilityReplicaUserPolicyDiscovery	Any	Internal
MSSQL on Windows: Local SQL Server Database Engines Discovery Source	Microsoft.SQLServer.Windows.DataSource.ClusterInstanceRelationshipDiscovery	Any	Internal
MSSQL on Windows: Database Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DatabaseDiscovery	Any	Internal
MSSQL on Windows: Database Replicas Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DatabaseReplicaDiscovery	Any	Internal
MSSQL on Windows: Database Replicas Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DatabaseReplicaDiscoveryProbe	Any	Internal
MSSQL on Windows: Database Replica Custom User Policy Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DatabaseReplicaUserPolicyDiscovery	Any	Internal
MSSQL on Windows: Data Source Database Memory-Optimized Data Resource Pools on Windows	Microsoft.SQLServer.Windows.DataSource.DatabaseResourcePool	Any	Internal
MSSQL on Windows: Custom User Policy Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DatabaseUserPolicyDiscovery	Any	Internal
MSSQL on Windows: DB Engine Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.DBEngineDiscovery	Any	Internal
MSSQL on Windows: DB File Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.FileDiscovery	Any	Internal
MSSQL on Windows: File Discovery Data Source on Windows	Microsoft.SQLServer.Windows.DataSource.FileDiscoveryProbe	Any	Internal
MSSQL on Windows: DB Filegroup Discovery Data Source on Windows	Microsoft.SQLServer.Windows.DataSource.FilegroupDiscovery	Any	Internal
MSSQL on Windows: DB Filegroup Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.FilegroupDiscoveryProbe	Any	Internal
MSSQL on Windows: General Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.GeneralAlwaysOnDiscovery	Any	Internal
MSSQL on Windows: Data Source for Local Alert Collection Target Discovery	Microsoft.SQLServer.Windows.DataSource.LocalAlertCollectionDiscovery	Any	Public
MSSQL on Windows: Local SQL Server Database Engines Discovery Source	Microsoft.SQLServer.Windows.DataSource.LocalDBEngineDiscovery	Any	Internal
MSSQL on Windows: Data Source for Discover Installation Source (seed)	Microsoft.SQLServer.Windows.DataSource.LocalDiscoverySeed	Any	Public
MSSQL on Windows: Data Source Database Engine Resource Pools on Windows	Microsoft.SQLServer.Windows.DataSource.ResourcePool	Any	Internal
MSSQL on Windows: Data Source Database Engine Resource Pools on Windows Probe	Microsoft.SQLServer.Windows.DataSource.ResourcePoolProbe	Any	Internal
MSSQL on Windows: Management pack discovery data source	Microsoft.SQLServer.Windows.DataSource.SqlMpDiscoveryDataSource	Any	Internal
MSSQL on Windows: Always On Custom User Policy Discovery Data Source	Microsoft.SQLServer.Windows.DataSource.UserPolicyDiscoveryProbe	Any	Internal

ProbeAction Modules (9)

DisplayName	ID	Isolation	Accessibility
MSSQL on Windows: Agent Probe Discovery	Microsoft.SQLServer.Windows.ProbeAction.AgentDiscovery	Any	Internal
MSSQL on Windows: Agent Job Probe Discovery	Microsoft.SQLServer.Windows.ProbeAction.AgentJobDiscovery	Any	Internal
MSSQL on Windows: Always On Seed Probe Discovery	Microsoft.SQLServer.Windows.ProbeAction.AlwaysOnSeedDiscovery	Any	Internal
MSSQL on Windows: Local DB Engine Management Relationship Probe Discovery on Windows	Microsoft.SQLServer.Windows.ProbeAction.ClusterInstanceRelationshipDiscovery	Any	Internal
MSSQL on Windows: Database Probe Discovery	Microsoft.SQLServer.Windows.ProbeAction.DatabaseDiscovery	Any	Internal
MSSQL on Windows: DB Engine Probe Discovery	Microsoft.SQLServer.Windows.ProbeAction.DBEngineDiscovery	Any	Internal
MSSQL on Windows: General Discovery Probe	Microsoft.SQLServer.Windows.ProbeAction.GeneralAlwaysOnDiscovery	Any	Internal
MSSQL on Windows: Local DB Engine Probe Discovery on Windows	Microsoft.SQLServer.Windows.ProbeAction.LocalDBEngineDiscovery	Any	Internal
MSSQL on Windows: Management pack discovery	Microsoft.SQLServer.Windows.ProbeAction.SqlManagementPackDiscovery	Any	Internal

WriteAction Modules (1)

	DisplayName	ID	Isolation	Accessibility
	MSSQL: Update or create and override	Microsoft.SQLServer.Windows.WriteAction.WriteOverride	Any	Internal

Discoveries (26)

DisplayName	ID	Target	Enabled
MSSQL on Windows: Discover Local SQL Server Database Engines Should Manage Relationship	Microsoft.SQLServer.Windows.ClusterInstanceRelationshipDiscovery	Microsoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeed	True
MSSQL on Windows: Discover SQL Server Agent for a Database Engine	Microsoft.SQLServer.Windows.Discovery.Agent	Microsoft.SQLServer.Windows.DBEngine	False
MSSQL on Windows: Discover SQL Server Agent Jobs	Microsoft.SQLServer.Windows.Discovery.AgentJob	Microsoft.SQLServer.Windows.Agent	False
MSSQL on Windows: Always On Seed Discovery	Microsoft.SQLServer.Windows.Discovery.AlwaysOnSeed	Microsoft.SQLServer.Windows.DBEngine	True
MSSQL on Windows: Availability Group Custom User Policy Discovery	Microsoft.SQLServer.Windows.Discovery.AvailabilityGroupUserPolicy	Microsoft.SQLServer.Windows.AvailabilityGroupHealth	False
MSSQL on Windows: Availability Replica Custom User Policy Discovery	Microsoft.SQLServer.Windows.Discovery.AvailabilityReplicaUserPolicy	Microsoft.SQLServer.Windows.AvailabilityReplica	False
MSSQL on Windows: Discover Memory-Optimized Data Filegroup Containers	Microsoft.SQLServer.Windows.Discovery.Container	Microsoft.SQLServer.Windows.DBFilegroupFx	False
MSSQL on Windows: Discover SQL Server Databases for a Database Engine	Microsoft.SQLServer.Windows.Discovery.Database	Microsoft.SQLServer.Windows.DBEngine	True
MSSQL on Windows: Database Replicas Discovery	Microsoft.SQLServer.Windows.Discovery.DatabaseReplica	Microsoft.SQLServer.Windows.AvailabilityReplica	True
MSSQL on Windows: Database Replica Custom User Policy Discovery	Microsoft.SQLServer.Windows.Discovery.DatabaseReplicaUserPolicy	Microsoft.SQLServer.Windows.DatabaseReplica	False
MSSQL on Windows: Discover Database Engine Resource Pool managing Memory-Optimized Data resources	Microsoft.SQLServer.Windows.Discovery.DatabaseResourcePool	Microsoft.SQLServer.Windows.Database	False
MSSQL on Windows: Discover Database Custom User Policy	Microsoft.SQLServer.Windows.Discovery.DatabaseUserPolicy	Microsoft.SQLServer.Windows.Database	False
MSSQL on Windows: Discover SQL Server Database Engines	Microsoft.SQLServer.Windows.Discovery.DBEngine	Microsoft.SQLServer.Windows.DBEngineSeed	True
MSSQL on Windows: SQL Server Express DB Engine Group Discovery	Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroup	Microsoft.SQLServer.Windows.DBEngineExpressGroup	True
MSSQL on Windows: DB Engine Group Discovery	Microsoft.SQLServer.Windows.Discovery.DBEngineGroup	Microsoft.SQLServer.Windows.DBEngineGroup	True
MSSQL on Windows: Discover SQL Server DB Files	Microsoft.SQLServer.Windows.Discovery.DBFile	Microsoft.SQLServer.Windows.DBFilegroup	True
MSSQL on Windows: Discover SQL Server DB Filegroups	Microsoft.SQLServer.Windows.Discovery.DBFilegroup	Microsoft.SQLServer.Windows.Database	True
MSSQL on Windows: Discover FILESTREAM Filegroups	Microsoft.SQLServer.Windows.Discovery.DBFilegroupFd	Microsoft.SQLServer.Windows.Database	True
MSSQL on Windows: Discover Memory-Optimized Data Filegroup	Microsoft.SQLServer.Windows.Discovery.DBFilegroupFx	Microsoft.SQLServer.Windows.Database	False
MSSQL on Windows: Discover SQL Server Transaction Log File	Microsoft.SQLServer.Windows.Discovery.DBLogFile	Microsoft.SQLServer.Windows.Database	True
MSSQL on Windows: General Always On Discovery	Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscovery	Microsoft.SQLServer.Windows.AlwaysOnSeed	True
MSSQL on Windows: Discover Installation Source (seed)	Microsoft.SQLServer.Windows.Discovery.LocalDiscoverySeed	Microsoft.Windows.Server.Computer	True
MSSQL on Windows: Discover Monitoring Pool Alert Collections	Microsoft.SQLServer.Windows.Discovery.MonitoringPoolAlertCollection	Microsoft.SystemCenter.AllManagementServersPool	True
MSSQL on Windows: Discover Database Engine Resource Pools	Microsoft.SQLServer.Windows.Discovery.ResourcePool	Microsoft.SQLServer.Windows.DBEngine	False
MSSQL on Windows: Discover Local Alert Collections	Microsoft.SQLServer.Windows.LocalAlertCollectionDiscovery	Microsoft.SQLServer.Windows.LocalDiscoverySeed	True
MSSQL on Windows: Discover Local SQL Server Database Engines	Microsoft.SQLServer.Windows.LocalDBEngineDiscovery	Microsoft.SQLServer.Windows.LocalDiscoverySeed	True

Rules (3)

DisplayName	ID	Target	Category	Enabled	Alert Generate
MSSQL on Windows: Automatic setup of DB Engine discovery filter	Microsoft.SQLServer.Windows.LocalDBEngineDiscoveryFilterSetup	Microsoft.SystemCenter.ManagementServer	Maintenance	True	False
MSSQL on Windows: Discovery error	Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.DiscoveryError	Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection	Alert	True	True
MSSQL on Windows: Discovery warning	Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.DiscoveryWarning	Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection	Alert	True	True

Discovery Property Overrides (5)

ID	Context	Target
Microsoft.SQLServer.Windows.DiscoveryPropertyOverride.Agent	Microsoft.SQLServer.Windows.Discovery.SqlAgentFeatureGroup	Microsoft.SQLServer.Windows.Discovery.Agent
Microsoft.SQLServer.Windows.DiscoveryPropertyOverride.Container	Microsoft.SQLServer.Windows.Discovery.InMemoryOltpFeatureGroup	Microsoft.SQLServer.Windows.Discovery.Container
Microsoft.SQLServer.Windows.DiscoveryPropertyOverride.DatabaseResourcePool	Microsoft.SQLServer.Windows.Discovery.SqlResurcePoolFeatureGroup	Microsoft.SQLServer.Windows.Discovery.DatabaseResourcePool
Microsoft.SQLServer.Windows.DiscoveryPropertyOverride.DBFilegroupFx	Microsoft.SQLServer.Windows.Discovery.InMemoryOltpFeatureGroup	Microsoft.SQLServer.Windows.Discovery.DBFilegroupFx
Microsoft.SQLServer.Windows.DiscoveryPropertyOverride.ResourcePool	Microsoft.SQLServer.Windows.Discovery.SqlResurcePoolFeatureGroup	Microsoft.SQLServer.Windows.Discovery.ResourcePool

Image References (2)

	DisplayName	ID	ImageID
	MSSQL on Windows: DB Memory-Optimized Data Container	Microsoft.SQLServer.Windows.Container	Microsoft.SQLServer.Core.Icons.Container.Image64
	MSSQL on Windows: DB Memory-Optimized Data Filegroup	Microsoft.SQLServer.Windows.DBFilegroupFx	Microsoft.SQLServer.Core.Icon.DBFilegroupFx.Image64

Deployable Assemblies (13)

ID	File Name	Accessibility
Microsoft.SQLServer.Core.Module.AlwaysOnHelper.Assembly	Microsoft.SQLServer.Core.Module.AlwaysOnHelper.dll	Public
Microsoft.SQLServer.Core.Module.Helper.Assembly	Microsoft.SQLServer.Core.Module.Helper.dll	Public
Microsoft.SQLServer.Module4.Helper.Assembly	Microsoft.SQLServer.Module4.Helper.dll	Public
Microsoft.SQLServer.Windows.Module.Discovery.Assembly	Microsoft.SQLServer.Windows.Module.Discovery.dll	Public
Smo.Microsoft.SqlServer.ConnectionInfo.Assembly	Microsoft.SqlServer.ConnectionInfo.dll	Public
Smo.Microsoft.SqlServer.Diagnostics.STrace.Assembly	Microsoft.SqlServer.Diagnostics.STrace.dll	Public
Smo.Microsoft.SqlServer.Dmf.Assembly	Microsoft.SqlServer.Dmf.dll	Public
Smo.Microsoft.SqlServer.Dmf.Common.Assembly	Microsoft.SqlServer.Dmf.Common.dll	Public
Smo.Microsoft.SqlServer.Management.Sdk.Sfc.Assembly	Microsoft.SqlServer.Management.Sdk.Sfc.dll	Public
Smo.Microsoft.SqlServer.PolicyEnum.Assembly	Microsoft.SqlServer.PolicyEnum.dll	Public
Smo.Microsoft.SqlServer.Smo.Assembly	Microsoft.SqlServer.Smo.dll	Public
Smo.Microsoft.SqlServer.SqlClrProvider.Assembly	Microsoft.SqlServer.SqlClrProvider.dll	Public
Smo.Microsoft.SqlServer.SqlEnum.Assembly	Microsoft.SqlServer.SqlEnum.dll	Public