Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member182521
Active Contributor

Hello Techies,

Continuing with my blog on visualization objects exploration, here is the one for objects used in Monitoring application. Let us see what I explored so far for monitoring application.

Queries for Probes

To list the available Probes

SELECT SI_ID, SI_NAME, SI_CLASSNAME FROM CI_INFOOBJECTS WHERE SI_KIND='MON.PROBE' AND SI_INSTANCE=0

Probes can be categorized as below based on their functionality as below

  1. Diagnostics
  2. Health
  3. Hybrid

To list the Diagnostic Probes

SELECT SI_ID,SI_NAME,SI_CLASSNAME FROM CI_INFOOBJECTS WHERE SI_KIND='MON.PROBE'

AND SI_PROBE_TYPE='DIAG' AND SI_INSTANCE=0

To list the Hybrid Probes

SELECT SI_ID,SI_NAME,SI_CLASSNAME FROM CI_INFOOBJECTS WHERE SI_KIND='MON.PROBE' AND SI_PROBE_TYPE='HYBRID' AND SI_INSTANCE=0

To list the Number of instances generated for probes (SI_CHILDREN)

SELECT SI_NAME,SI_CHILDREN FROM CI_INFOOBJECTS WHERE SI_KIND='MON.PROBE' AND SI_INSTANCE=0

To list the Last Execution time and Run time of the probe


SELECT SI_ID,SI_NAME,SI_EXECTIME,SI_LAST_RUN_TIME FROM CI_INFOOBJECTS

WHERE SI_KIND='MON.PROBE' AND SI_INSTANCE=0

Queries for Watches

To get the list of Watches

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND= 'MON.ManagedEntityStatus'

To get the Caution and Danger rule of the watch

SELECT SI_NAME,SI_AMBER_CONDITION, SI_RED_CONDITION FROM CI_APPOBJECTS

WHERE SI_KIND= 'MON.ManagedEntityStatus' AND SI_NAME='CentralManagementServer Watch'

To get the Throttle and Notification settings of Caution and Danger rules of each watch

SELECT SI_NAME,SI_AMBER_THROTTLING_DETAILS, SI_RED_THROTTLING_DETAILS,

SI_NOTIFICATION_SETTINGS, SI_EMAIL_ENABLED_FOR_RED,SI_EMAIL_ENABLED_FOR_AMBER

FROM CI_APPOBJECTS WHERE SI_KIND= 'MON.ManagedEntityStatus'

Hope this would be useful for those who are searching for monitoring application metadata.


Query Builder Blog series

Basics

             BusinessObjects Query builder - Basics

              BusinessObjects Query builder – Best practices & Usability

Sample Queries

             BusinessObjects Query builder queries

               BusinessObjects Query builder queries - Part II

               BusinessObjects Query builder queries - Part III

               BusinessObjects Query builder queries - Part IV

               BusinessObjects Query builder – Exploring Visualization Objects

              BusinessObjects Query builder – Exploring Monitoring Objects

              BusinessObjects Query builder - Exploring Lumira & Design studio Objects


Use cases

               BusinessObjects Environment assessment using Query builder

               BusinessObjects Environment Cleanup using Query builder

               BusinessObjects Query builder – What's New in BI 4.0   

8 Comments
Labels in this area