Skip to Content

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   

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Chandrasekhar Reddy kothapalli

    Good information Mani . is there any query to find the list of users in the publications. EX : I have 50 publications and 200 INSTANCE one publication 5 users like . I wont to know the users list for all the publications.

    (0) 
  2. Madhu Mottala

    Hi Manikandam, it’s a great information.

    I have a query.

    I have got around 300 of Deski reports in our environment. Here my question is how can we get the complete history of this reports like Developed date, last run or refreshed date, user or owner of the report etc.

    We are on BOXI 3.1.

    Please help me in this.

     

    Thanks in Advance,

    Regards,

    Madhu

    (0) 

Leave a Reply