Answered by:
Monitor Reset Mode

-
Hello!
If it possible for each monitor currently installed in a SCOM RMS I would like to know if its reset is automatic or manual:
- with automatic I mean based on another event (for example Windows Event or on Performances) or on Time Reset.
- with manual I mean reset by operator.
I thought to use some Powershell Scripts but I do not know wich field select.
Any hint?
Thank you!
Lizzie
Question
Answers
-
Here is a simple one which lists monitors with a monitor type that contains "manual":
USE OperationsManager
SELECT MTV.DisplayName
FROM MonitorView MTV
INNER JOIN MonitorType MTT
ON MTT.MonitorTypeId = MTV.MonitorTypeId
WHERE MTT.MNTName LIKE '%Manual%'
GROUP BY MTV.DisplayName
I used a "GROUP BY" because there are two entries in the table for user-generated monitors, maybe because of languages...anyway if you need more data in the result, tell me.- Marked as answer by StuartRModerator Thursday, August 27, 2009 7:53 PM
All replies
-
-
-
Here is a simple one which lists monitors with a monitor type that contains "manual":
USE OperationsManager
SELECT MTV.DisplayName
FROM MonitorView MTV
INNER JOIN MonitorType MTT
ON MTT.MonitorTypeId = MTV.MonitorTypeId
WHERE MTT.MNTName LIKE '%Manual%'
GROUP BY MTV.DisplayName
I used a "GROUP BY" because there are two entries in the table for user-generated monitors, maybe because of languages...anyway if you need more data in the result, tell me.- Marked as answer by StuartRModerator Thursday, August 27, 2009 7:53 PM
-
hey lizzie, here's one i wrote up which should give you all of the pertinent data you require to go chase them down:
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%'
also, don't forget about this gem: http://blogs.technet.com/timhe/archive/2009/01/15/announcing-the-greenmachine-utility-for-operationsmanager-rtm-sp1-and-r2.aspx
::marcus _ marcusoh.blogspot.com- Proposed as answer by Shreedevi Padmasini [MSFT]Moderator Thursday, July 23, 2009 6:10 PM
-
-
Marcus, is the "management pack" displayed in the results the management pack for the *monitor* or for the *monitor type*? i'm showing a bunch of monitors with "sharepoint" in their display names, but the MP in the query says Microsoft.Windows.Library. is there a way to display the management pack that the actual monitor is in?