Skip to Content
Author's profile photo Manikandan Elumalai

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   

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Collection Manikandan....Thank you for sharing.

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo N Muralidhar Reddy
      N Muralidhar Reddy

      Hi Manikandan,

      Thanks for your great information above. However, What should we write to see all the list of Tabs and other objects like Blocks, Charts, Tables in a WEBi report?

       

      Regards

      Murali

      Author's profile photo Joe Peters
      Joe Peters

      That is not available via CMS queries.  You need to use the REST API.

      Author's profile photo N Muralidhar Reddy
      N Muralidhar Reddy

      Hi Joe,

       

      Thanks for the reply. Can you help me in understanding more about this REST API please.

       

      Thanks

      Murali

      Author's profile photo Joe Peters
      Joe Peters

      You can find the documentation on the BI4.2 Help Page.  Look for "RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer"

      Author's profile photo rena winton
      rena winton

       

      what is the sql to find the user that last updated a Webi report