All Discoveries in Microsoft.SQLServer.Windows.Discovery Management Pack

 DisplayNameDescriptionIDTargetEnabledFrequencyRemotable
Microsoft.SQLServer.Windows.ClusterInstanceRelationshipDiscoveryMSSQL on Windows: Discover Local SQL Server Database Engines Should Manage RelationshipThis rule discovers Local SQL Server DB Engines Should Manage Relationship on Windows.Microsoft.SQLServer.Windows.ClusterInstanceRelationshipDiscoveryMicrosoft.SQLServer.Windows.LocalClusteredDBEngineDiscoverySeedTrue60False
Microsoft.SQLServer.Windows.Discovery.AgentMSSQL on Windows: Discover SQL Server Agent for a Database EngineThis rule discovers the SQL Server Agent for an instance of SQL Server DB Engine on Windows. There could be only one SQL Server Agent instance for each DB Engine instance.Microsoft.SQLServer.Windows.Discovery.AgentMicrosoft.SQLServer.Windows.DBEngineFalse14400False
Microsoft.SQLServer.Windows.Discovery.AgentJobMSSQL on Windows: Discover SQL Server Agent JobsThis rule discovers all SQL Server Agent Jobs on WindowsMicrosoft.SQLServer.Windows.Discovery.AgentJobMicrosoft.SQLServer.Windows.AgentFalse14400False
Microsoft.SQLServer.Windows.Discovery.AlwaysOnSeedMSSQL on Windows: Always On Seed DiscoveryThis discovery is used to define which instances have Always On enabled.Microsoft.SQLServer.Windows.Discovery.AlwaysOnSeedMicrosoft.SQLServer.Windows.DBEngineTrue14400False
Microsoft.SQLServer.Windows.Discovery.AvailabilityGroupUserPolicyMSSQL on Windows: Availability Group Custom User Policy DiscoveryDiscovery of Custom User Policies for Always On Availability Groups. Note: This discovery is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.Windows.Discovery.AvailabilityGroupUserPolicyMicrosoft.SQLServer.Windows.AvailabilityGroupHealthFalse14400False
Microsoft.SQLServer.Windows.Discovery.AvailabilityReplicaUserPolicyMSSQL on Windows: Availability Replica Custom User Policy DiscoveryDiscovery of Custom User Policies for Always On Availability Replicas. Note: This discovery is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.Windows.Discovery.AvailabilityReplicaUserPolicyMicrosoft.SQLServer.Windows.AvailabilityReplicaFalse14400False
Microsoft.SQLServer.Windows.Discovery.ContainerMSSQL on Windows: Discover Memory-Optimized Data Filegroup ContainersThis rule discovers the container information for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.ContainerMicrosoft.SQLServer.Windows.DBFilegroupFxFalse14400False
Microsoft.SQLServer.Windows.Discovery.DatabaseMSSQL on Windows: Discover SQL Server Databases for a Database EngineThis rule discovers all databases running for a given instance of SQL Server DB Engine on Windows.Microsoft.SQLServer.Windows.Discovery.DatabaseMicrosoft.SQLServer.Windows.DBEngineTrue14400False
Microsoft.SQLServer.Windows.Discovery.DatabaseReplicaMSSQL on Windows: Database Replicas DiscoveryDiscovery of database replica Always On objects.Microsoft.SQLServer.Windows.Discovery.DatabaseReplicaMicrosoft.SQLServer.Windows.AvailabilityReplicaTrue14400False
Microsoft.SQLServer.Windows.Discovery.DatabaseReplicaUserPolicyMSSQL on Windows: Database Replica Custom User Policy DiscoveryDiscovery of Custom User Policies for Always On Database Replicas. Note: This discovery is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.Windows.Discovery.DatabaseReplicaUserPolicyMicrosoft.SQLServer.Windows.DatabaseReplicaFalse14400False
Microsoft.SQLServer.Windows.Discovery.DatabaseResourcePoolMSSQL on Windows: Discover Database Engine Resource Pool managing Memory-Optimized Data resourcesThis rule discovers a resource pool that manages Memory-Optimized Data resources of the target SQL Server database and a relation between Resource Pool and the database.Microsoft.SQLServer.Windows.Discovery.DatabaseResourcePoolMicrosoft.SQLServer.Windows.DatabaseFalse14400False
Microsoft.SQLServer.Windows.Discovery.DatabaseUserPolicyMSSQL on Windows: Discover Database Custom User PolicyThis rule discovers Custom User Policies for SQL Server Database on Windows. Note: This discovery is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.Windows.Discovery.DatabaseUserPolicyMicrosoft.SQLServer.Windows.DatabaseFalse14400False
Microsoft.SQLServer.Windows.Discovery.DBEngineMSSQL on Windows: Discover SQL Server Database Engines (Agentless)This rule discovers SQL Server DB Engines on Windows (Agentless).Microsoft.SQLServer.Windows.Discovery.DBEngineMicrosoft.SQLServer.Windows.DBEngineSeedTrue14400False
Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroupMSSQL on Windows: SQL Server Express DB Engine Group DiscoveryThis discovery rule populates the Express Group on Windows with all SQL Server Express DBEngines on Windows.Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroupMicrosoft.SQLServer.Windows.DBEngineExpressGroupTrue0False
Microsoft.SQLServer.Windows.Discovery.DBEngineGroupMSSQL on Windows: DB Engine Group DiscoveryMicrosoft SQL Server DB Engine Group Discovery on Windows.Microsoft.SQLServer.Windows.Discovery.DBEngineGroupMicrosoft.SQLServer.Windows.DBEngineGroupTrue0False
Microsoft.SQLServer.Windows.Discovery.DBFileMSSQL on Windows: Discover SQL Server DB FilesThis rule discovers the file information for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.DBFileMicrosoft.SQLServer.Windows.DBFilegroupTrue14400False
Microsoft.SQLServer.Windows.Discovery.DBFilegroupMSSQL on Windows: Discover SQL Server DB FilegroupsThis rule discovers the Filegroup information for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.DBFilegroupMicrosoft.SQLServer.Windows.DatabaseTrue14400False
Microsoft.SQLServer.Windows.Discovery.DBFilegroupFdMSSQL on Windows: Discover FILESTREAM FilegroupsThis rule discovers DB FILESTREAM Filegroup information for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.DBFilegroupFdMicrosoft.SQLServer.Windows.DatabaseTrue14400False
Microsoft.SQLServer.Windows.Discovery.DBFilegroupFxMSSQL on Windows: Discover Memory-Optimized Data FilegroupThis rule discovers the Memory-Optimized Data Filegroup information for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.DBFilegroupFxMicrosoft.SQLServer.Windows.DatabaseFalse14400False
Microsoft.SQLServer.Windows.Discovery.DBLogFileMSSQL on Windows: Discover SQL Server Transaction Log FileThis rule discovers transaction log files for each SQL Server Database on Windows.Microsoft.SQLServer.Windows.Discovery.DBLogFileMicrosoft.SQLServer.Windows.DatabaseTrue14400False
Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscoveryMSSQL on Windows: General Always On DiscoveryThis discovery is used to define which instances have Always On enabled.Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscoveryMicrosoft.SQLServer.Windows.AlwaysOnSeedTrue14400False
Microsoft.SQLServer.Windows.Discovery.LocalDiscoverySeedMSSQL on Windows: Discover Installation Source (seed)This rule discovers a seed for MSSQL on Windows installation. This object indicates that the particular server computer contains MSSQL on Windows installation.Microsoft.SQLServer.Windows.Discovery.LocalDiscoverySeedMicrosoft.Windows.Server.ComputerTrue14400False
Microsoft.SQLServer.Windows.Discovery.MonitoringPoolAlertCollectionMSSQL on Windows: Discover Monitoring Pool Alert CollectionsThis rule discovers a Monitoring Pool Alert Collection for a MSSQL on Windows. This object is used to collect module errors and warnings from event log of nodes that are the members of the SQL Server Monitoring Pool.Microsoft.SQLServer.Windows.Discovery.MonitoringPoolAlertCollectionMicrosoft.SystemCenter.AllManagementServersPoolTrue14400False
Microsoft.SQLServer.Windows.Discovery.ResourcePoolMSSQL on Windows: Discover Database Engine Resource PoolsThis rule discovers all resource pools for a given instance of SQL Server DB Engine.Microsoft.SQLServer.Windows.Discovery.ResourcePoolMicrosoft.SQLServer.Windows.DBEngineFalse14400False
Microsoft.SQLServer.Windows.LocalAlertCollectionDiscoveryMSSQL on Windows: Discover Local Alert CollectionsThis rule discovers a Local Alert Collection for a MSSQL on Windows. This object is used to collect module errors and warnings from event log of SCOM agents that monitor Local SQL Server DB Engine instances.Microsoft.SQLServer.Windows.LocalAlertCollectionDiscoveryMicrosoft.SQLServer.Windows.LocalDiscoverySeedTrue14400False
Microsoft.SQLServer.Windows.LocalDBEngineDiscoveryMSSQL on Windows: Discover SQL Server Database Engines (Local)This rule discovers SQL Server DB Engines on Windows (Local).Microsoft.SQLServer.Windows.LocalDBEngineDiscoveryMicrosoft.SQLServer.Windows.LocalDiscoverySeedTrue14400False