locked
how to find what are all the rules and events are monitoring for specific server in SCOM 2007 RRS feed

  • Question

  • how to find what are all the rules and events are monitoring for specific server in SCOM 2007.

    I need to know what are all the events, services, and rules are monitored for the specific server.

    Kindly help me friends.

    Thursday, March 31, 2011 2:01 PM

Answers

  • Hi Sandoss Kumar,

    You have three ways of doing this :

    1 ) Using SCOM Console - Monitoring --> Operations Manager --> Agent --> Agent by version , select computer with agent you want to see the rules and monitors and run the task "Show running rules and monitors running for this health service". This will give the output you need.

    2 ) Using the SCOM Reporting. For that go to SCOM console --> Reporting -->Operational Data Reporting Management Pack --> Management pack Report. This report will give you all the overrides done by management pack and what rules are being applied to the target computer / agent.

    3 ) Other solution is try to use "SC Ops Mgr 2007 Resource Kit – Effective Configuration Viewer" Tool. This will give you a overview over all monitors and rules for what you are looking into. However if you want to check what "windows services" are being monitored check you SCOM console on authoring and check on management pack templates --> windows services what is being deployed or not to be monitored on the specific machine.

    Gonna give you a direct link to download the Effective Configuration Viewer :

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=A9DB4DCA-6716-478D-89B9-42F27EBC76A8&displaylang=en

    Hope this helps you.

    Best Regards,

    Paulo J. Mendes

    • Proposed as answer by Paulo J. Mendes Thursday, March 31, 2011 2:20 PM
    • Edited by Paulo J. Mendes Thursday, March 31, 2011 2:28 PM 3rd solution added
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 2:10 PM
  • Hi all.

    ECV (Effective Configuration Viewer) does not work well with SCOM R2. Posted a blog article about it: http://thoughtsonopsmgr.blogspot.com/2009/09/opsmgr-effective-configuration-viewer.html


    Best regards, Marnix Wolf

    (Thoughts on OpsMgr)
    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:15 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 2:33 PM
  • MP Tuner should do this (mpwiki.viacode.com)

     


    Microsoft Corporation
    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:15 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 3:22 PM
  • One of th eissues is that you can see what rules and monitors are running on an agent but trying to get the overrides applied to those as well is quite difficult. Check out this post by Stefan Stranger.

     

    http://blogs.technet.com/b/stefan_stranger/archive/2010/11/30/what-monitors-rules-and-discoveries-are-running-on-an-opsmgr-agent.aspx

    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:17 AM
    Friday, April 1, 2011 10:09 AM

All replies

  • Hi Sandoss Kumar,

    You have three ways of doing this :

    1 ) Using SCOM Console - Monitoring --> Operations Manager --> Agent --> Agent by version , select computer with agent you want to see the rules and monitors and run the task "Show running rules and monitors running for this health service". This will give the output you need.

    2 ) Using the SCOM Reporting. For that go to SCOM console --> Reporting -->Operational Data Reporting Management Pack --> Management pack Report. This report will give you all the overrides done by management pack and what rules are being applied to the target computer / agent.

    3 ) Other solution is try to use "SC Ops Mgr 2007 Resource Kit – Effective Configuration Viewer" Tool. This will give you a overview over all monitors and rules for what you are looking into. However if you want to check what "windows services" are being monitored check you SCOM console on authoring and check on management pack templates --> windows services what is being deployed or not to be monitored on the specific machine.

    Gonna give you a direct link to download the Effective Configuration Viewer :

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=A9DB4DCA-6716-478D-89B9-42F27EBC76A8&displaylang=en

    Hope this helps you.

    Best Regards,

    Paulo J. Mendes

    • Proposed as answer by Paulo J. Mendes Thursday, March 31, 2011 2:20 PM
    • Edited by Paulo J. Mendes Thursday, March 31, 2011 2:28 PM 3rd solution added
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 2:10 PM
  • Hi all.

    ECV (Effective Configuration Viewer) does not work well with SCOM R2. Posted a blog article about it: http://thoughtsonopsmgr.blogspot.com/2009/09/opsmgr-effective-configuration-viewer.html


    Best regards, Marnix Wolf

    (Thoughts on OpsMgr)
    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:15 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 2:33 PM
  • MP Tuner should do this (mpwiki.viacode.com)

     


    Microsoft Corporation
    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:15 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    Thursday, March 31, 2011 3:22 PM
  • One of th eissues is that you can see what rules and monitors are running on an agent but trying to get the overrides applied to those as well is quite difficult. Check out this post by Stefan Stranger.

     

    http://blogs.technet.com/b/stefan_stranger/archive/2010/11/30/what-monitors-rules-and-discoveries-are-running-on-an-opsmgr-agent.aspx

    • Proposed as answer by Nicholas Li Monday, April 4, 2011 3:16 AM
    • Marked as answer by Nicholas Li Monday, April 4, 2011 3:17 AM
    Friday, April 1, 2011 10:09 AM
  • how to find what are all the rules and events are monitoring for specific server in SCOM 2007.

    I need to know what are all the events, services, and rules are monitored for the specific server.

    Kindly help me friends.


    Thanks for the question Sandoss. This is something that we all come across at sometime.
    Thanks & regards, Sumit Agrawal

    The lack of this feature is an inexcusable oversight for an enterprise management product.  They have some serious lightweights making design decisions on the SCOM team. 5 thumbs down. 

    BTW the answer is probably LOTS of stuff. Literally 100's of workflows are running on any server. 

    The following OpsMgr DB query will list all running monitors on a server. Change the name of @srv. I think this works pretty well.  I'd like some feedback if something is missing.

    DECLARE @srv varchar(30)
    SET @srv = 'your name here'

    SELECT mon.displayName as monitor, bme.FullName,bme.DisplayName as object,
    case
        when s.HealthState = 1 then 'healthy'
        when s.HealthState = 2 then 'Warning'
        when s.HealthState = 3 then 'Critical'
        else 'N/A'
    end as Health
    FROM state AS s WITH (NOLOCK)
    left join BaseManagedEntity as bme WITH (NOLOCK) on s.basemanagedentityid = bme.basemanagedentityid
    left join dbo.MonitorView Mon WITH (NOLOCK) on Mon.ID = s.monitorid
    where
    bme.FullName like '%' + @srv + '%'
    and s.HealthState <> 0
    and mon.IsInternalRollupMonitor = 0
    and mon.IsExternalRollupMonitor = 0
    order by bme.DisplayName, mon.displayName

    Thursday, September 22, 2011 5:45 PM
  • I am kinda  ok when it comes to SCOM but I like to prepare for the worse. .......what about for all servers? not just for a specific server.  I will use your SQL query....but can I use a wildcard * ?

    Wednesday, January 25, 2012 4:48 AM
  • Hi SCOMCat,

    Its a great query indeed to check the monitor status. Could you please refine this to include the rules targeting as well.

    Thanks,

    Binoy Das

    Tuesday, September 2, 2014 10:00 AM