sql query to list all manual reset monitors

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.

SELECT mv.name,
       mv.enabled,
       mv.displayname,
       mtv.name,
       mpv.name
  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.