O R G A N I C / F E R T I L I Z E R: sql query to list all manual reset monitors

Jul 24, 2009

sql query to list all manual reset monitors

Batch Monitor

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.