| DisplayName | Description | ID | Target | Enabled | Frequency | Remotable |
| MSSQL on Windows: Discover SQL Server Agent for a Database Engine | This 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.Agent | Microsoft.SQLServer.Windows.DBEngine | True | 14400 | False |
| MSSQL on Windows: Discover SQL Server Agent Jobs | This rule discovers all SQL Server Agent Jobs on Windows | Microsoft.SQLServer.Windows.Discovery.AgentJob | Microsoft.SQLServer.Windows.Agent | False | 14400 | False |
| MSSQL on Windows: Always On Seed Discovery | This discovery is used to define which instances have Always On enabled. | Microsoft.SQLServer.Windows.Discovery.AlwaysOnSeed | Microsoft.SQLServer.Windows.DBEngine | True | 14400 | False |
| MSSQL on Windows: Availability Group Custom User Policy Discovery | Discovery 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.AvailabilityGroupUserPolicy | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | False | 14400 | False |
| MSSQL on Windows: Availability Replica Custom User Policy Discovery | Discovery 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.AvailabilityReplicaUserPolicy | Microsoft.SQLServer.Windows.AvailabilityReplica | False | 14400 | False |
| MSSQL on Windows: Discover Memory-Optimized Data Filegroup Containers | This rule discovers the container information for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.Container | Microsoft.SQLServer.Windows.DBFilegroupFx | True | 14400 | False |
| MSSQL on Windows: Discover SQL Server Databases for a Database Engine | This rule discovers all databases running for a given instance of SQL Server DB Engine on Windows. | Microsoft.SQLServer.Windows.Discovery.Database | Microsoft.SQLServer.Windows.DBEngine | True | 14400 | False |
| MSSQL on Windows: Database Replicas Discovery | Discovery of database replica Always On objects. | Microsoft.SQLServer.Windows.Discovery.DatabaseReplica | Microsoft.SQLServer.Windows.AvailabilityReplica | True | 14400 | False |
| MSSQL on Windows: Database Replica Custom User Policy Discovery | Discovery 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.DatabaseReplicaUserPolicy | Microsoft.SQLServer.Windows.DatabaseReplica | False | 14400 | False |
| MSSQL on Windows: Discover Database Engine Resource Pool managing Memory-Optimized Data resources | This 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.DatabaseResourcePool | Microsoft.SQLServer.Windows.Database | True | 14400 | False |
| MSSQL on Windows: Discover Database Custom User Policy | This 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.DatabaseUserPolicy | Microsoft.SQLServer.Windows.Database | False | 14400 | False |
| MSSQL on Windows: Discover SQL Server Database Engines | This rule discovers SQL Server DB Engines on Windows. | Microsoft.SQLServer.Windows.Discovery.DBEngine | Microsoft.SQLServer.Windows.DBEngineSeed | True | 14400 | False |
| MSSQL on Windows: DB Engine Express Group Discovery | This discovery rule populates the Express Group on Windows with all SQL Server Express DBEngines on Windows. | Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroup | Microsoft.SQLServer.Windows.DBEngineExpressGroup | True | 0 | False |
| MSSQL on Windows: DB Engine Group Discovery | Microsoft SQL Server DB Engine Group Discovery on Windows. | Microsoft.SQLServer.Windows.Discovery.DBEngineGroup | Microsoft.SQLServer.Windows.DBEngineGroup | True | 0 | False |
| MSSQL on Windows: Discover SQL Server DB Files | This rule discovers the file information for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.DBFile | Microsoft.SQLServer.Windows.DBFilegroup | True | 14400 | False |
| MSSQL on Windows: Discover SQL Server DB Filegroups | This rule discovers the Filegroup information for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.DBFilegroup | Microsoft.SQLServer.Windows.Database | True | 14400 | False |
| MSSQL on Windows: Discover FILESTREAM Filegroups | This rule discovers DB FILESTREAM Filegroup information for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.DBFilegroupFd | Microsoft.SQLServer.Windows.Database | True | 14400 | False |
| MSSQL on Windows: Discover Memory-Optimized Data Filegroup | This rule discovers the Memory-Optimized Data Filegroup information for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.DBFilegroupFx | Microsoft.SQLServer.Windows.Database | True | 14400 | False |
| MSSQL on Windows: Discover SQL Server Transaction Log File | This rule discovers transaction log files for each SQL Server Database on Windows. | Microsoft.SQLServer.Windows.Discovery.DBLogFile | Microsoft.SQLServer.Windows.Database | True | 14400 | False |
| MSSQL on Windows: General Always On Discovery | This discovery is used to define which instances have Always On enabled. | Microsoft.SQLServer.Windows.Discovery.GeneralAlwaysOnDiscovery | Microsoft.SQLServer.Windows.AlwaysOnSeed | True | 14400 | False |
| MSSQL 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.LocalDiscoverySeed | Microsoft.Windows.Server.Computer | True | 14400 | False |
| MSSQL on Windows: Discover Monitoring Pool Alert Collections | This 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.MonitoringPoolAlertCollection | Microsoft.SystemCenter.AllManagementServersPool | True | 14400 | False |
| MSSQL on Windows: Discover Database Engine Resource Pools | This rule discovers all resource pools for a given instance of SQL Server DB Engine. | Microsoft.SQLServer.Windows.Discovery.ResourcePool | Microsoft.SQLServer.Windows.DBEngine | True | 14400 | False |
| MSSQL on Windows: Discover Local Alert Collections | This 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.LocalAlertCollectionDiscovery | Microsoft.SQLServer.Windows.LocalDiscoverySeed | True | 14400 | False |
| MSSQL on Windows: Discover Local SQL Server Database Engines | This rule discovers Local SQL Server DB Engines on Windows. | Microsoft.SQLServer.Windows.LocalDBEngineDiscovery | Microsoft.SQLServer.Windows.LocalDiscoverySeed | True | 14400 | False |