Image via Wikipedia
looking for an easy way to list all of your unit monitors classified as a manual reset? here’s a sql query that you can execute to list them out.
FROM monitorview mv
inner join monitortypeview mtv on mv.monitortypeid=mtv.id
inner join managementpackview mpv on mtv.managementpackid = mpv.id
WHERE mv.IsUnitMonitor = 'True' and
mtv.name like '%manualreset%'
you can follow the entire thread here.