VIEW: DBSNMP.MGMT_BSLN_THRESHOLD_PARMS

Source

View Text - Preformatted

select btp.bsln_guid
      ,bsln.datasource_guid(bsln.target_uid(bb.dbid, i.instance_number),
                            bsln.metric_uid(btp.metric_id))
      ,btp.threshold_method
      ,btp.num_occurrences
      ,btp.warning_param
      ,btp.critical_param
      ,btp.fail_action
  from bsln_threshold_params btp, bsln_baselines bb, gv$instance i
 where btp.bsln_guid = bb.bsln_guid
   and bb.instance_name = i.instance_name

View Text - HTML Formatted

SELECT BTP.BSLN_GUID
, BSLN.DATASOURCE_GUID(BSLN.TARGET_UID(BB.DBID
, I.INSTANCE_NUMBER)
, BSLN.METRIC_UID(BTP.METRIC_ID))
, BTP.THRESHOLD_METHOD
, BTP.NUM_OCCURRENCES
, BTP.WARNING_PARAM
, BTP.CRITICAL_PARAM
, BTP.FAIL_ACTION
FROM BSLN_THRESHOLD_PARAMS BTP
, BSLN_BASELINES BB
, GV$INSTANCE I
WHERE BTP.BSLN_GUID = BB.BSLN_GUID
AND BB.INSTANCE_NAME = I.INSTANCE_NAME