[SQL & SCOM] List all Manual Reset Monitors

Here is a short SQL script to use to retrieve the Name of each Manual Reset Monitor. The aim was to identify these monitors in the connector.

1. Select Monitor.MonitorName, MNTSName
2. From [OperationsManager].[dbo].[MonitorTypeState] MTS
3. Inner join OperationsManager.dbo.MonitorType MT With (NOLOCK) on MT.MonitorTypeId = MTS. MonitorTypeId
4. Inner join Monitor with (NOLOCK) on Monitor. MonitorTypeId = MT. MonitorTypeId
5. Where MNTSName like '%ManualReset%'

Result should be like :

MonitorName	MNTSName
Microsoft.Windows.Server.2000.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised
Microsoft.Windows.Server.2003.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised
Microsoft.Windows.Server.2008.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised