Monday, July 20, 2009 2:29 PM
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.
Thursday, July 23, 2009 10:23 AMHi Lizzie,
Does querying the OperationsManager database would be a solution for you ? or do you really want to use powershell ?
Thursday, July 23, 2009 11:04 AMfor me is ok also via DB Query but I have not idea which table query and what query use.
Have you some suggestion (for example a query :-) ) ?
Thursday, July 23, 2009 12:24 PM
Here is a simple one which lists monitors with a monitor type that contains "manual":
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
Thursday, July 23, 2009 12:42 PMModeratorhey 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 PadmasiniMicrosoft Employee, Moderator Thursday, July 23, 2009 6:10 PM
Friday, July 24, 2009 1:03 PMHello!
Thank you both!
They are two very useful queries!
@Marcus: I've already emplyed the tool you posted. It's very useful! Thank you so much!
Wednesday, May 30, 2012 3:36 PMMarcus, 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?