locked
need a sql query run on DW DB to report the agent which are in greyed-out RRS feed

  • Question

  • Hi,

    I am looking a sql query run on DW DB to report the agent which are in greyed-out. I have a query which can be run in the OPS DB. We're planning to run teh report few times in a day. Due to this fact, we don't want to touch the OPS DB very often. Please share with me if anyone have the SQL query run on DW DB.

    Regards,

    Fid-SCOM

     

     

    • Changed type Fid-SCOM Friday, May 7, 2010 9:50 PM Wrong forum
    • Changed type Fid-SCOM Friday, May 7, 2010 9:51 PM General Discussion
    Friday, May 7, 2010 9:37 PM

Answers

  • The unreachable state is no propagated to the DW, you can use the dbo.vHealthServiceOutage table or check for last perf point or event collected

     


    - Daniele, Microsoft MVP OpsMgr This posting is provided "AS IS" with no warranties, and confers no rights. http://nocentdocent.wordpress.com http://www.progel.it
    • Marked as answer by Nicholas Li Tuesday, May 25, 2010 3:22 AM
    Saturday, May 8, 2010 8:53 AM
  • Hi,

     

    Please also refer to the following article and note Nayden’s reply:

     

    Useful Operations Manager 2007 SQL queries

    http://blogs.technet.com/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx

     

    Hope this helps. Thanks.


    Nicholas Li - MSFT
    • Marked as answer by Nicholas Li Tuesday, May 25, 2010 3:22 AM
    Monday, May 10, 2010 8:40 AM

All replies

  • The unreachable state is no propagated to the DW, you can use the dbo.vHealthServiceOutage table or check for last perf point or event collected

     


    - Daniele, Microsoft MVP OpsMgr This posting is provided "AS IS" with no warranties, and confers no rights. http://nocentdocent.wordpress.com http://www.progel.it
    • Marked as answer by Nicholas Li Tuesday, May 25, 2010 3:22 AM
    Saturday, May 8, 2010 8:53 AM
  • Hi,

     

    Please also refer to the following article and note Nayden’s reply:

     

    Useful Operations Manager 2007 SQL queries

    http://blogs.technet.com/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx

     

    Hope this helps. Thanks.


    Nicholas Li - MSFT
    • Marked as answer by Nicholas Li Tuesday, May 25, 2010 3:22 AM
    Monday, May 10, 2010 8:40 AM
  • Thanks for your replies. I will check and let all know.
    Monday, May 17, 2010 6:21 PM