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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |