BusinessObjects Query builder – Exploring Monitoring Objects

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