Sign in
 
Home2012Previous VersionsLibraryForumsGallery

none
Monitor Reset Mode

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Monday, July 20, 2009 2:29 PM
    |

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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.

    Thursday, July 23, 2009 12:24 PM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Lizzie,

    Does querying the OperationsManager database would be a solution for you ? or do you really want to use powershell ?
    Thursday, July 23, 2009 10:23 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    for 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 :-)  ) ?

    Thank you!
    Lizzie
    Thursday, July 23, 2009 11:04 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote

    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.

    Thursday, July 23, 2009 12:24 PM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote
    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
    Thursday, July 23, 2009 12:42 PM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello!
    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!

    Bye!

    Lizzie
    Friday, July 24, 2009 1:03 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    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?
    Wednesday, May 30, 2012 3:36 PM
    |