Show TOC

System Monitoring App: Individual Metrics Locate this document in the navigation structure

Query Query: 0SMD_DASH_SYSMON_SINGLE_METRIC

 

This query is used for the detail app of the dashboard apps for technical operation, (App for System Performance and App for System Availability). A detail app is called when you click the corresponding element of the underlying app in the context of a drill down, and the development over time of an individual metric is then displayed. This query determines the data required for this.

Structure

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Calendar Month

0CALMONTH

Calendar Day

0CALDAY

Time (Hour)

0SMD_TIHH

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Gray

'Rated Metric: Gray [0SMD_R_GRAY]' / ( 'Rated Metric: Gray [0SMD_R_GRAY]' +'Rated Metric: Green [0SMD_R_GREE]' + 'Rated Metric: Yellow [0SMD_R_YELL]' + 'Rated Metric: Red [0SMD_R_RED]' ) * 100

Green

'Rated Metric: Green[0SMD_R_GREE]' / ( 'Rated Metric: Gray [0SMD_R_GRAY]' +'Rated Metric: Green [0SMD_R_GREE]' + 'Rated Metric: Yellow [0SMD_R_YELL]' + 'Rated Metric: Red [0SMD_R_RED]' ) * 100

Yellow

'Rated Metric: Yellow [0SMD_R_YELL]' / ( 'Rated Metric: Gray [0SMD_R_GRAY]' +'Rated Metric: Green [0SMD_R_GREE]' + 'Rated Metric: Yellow [0SMD_R_YELL]' + 'Rated Metric: Red [0SMD_R_RED]' ) * 100

Red

'Rated Metric: Red [0SMD_R_RED]' / ( 'Rated Metric: Gray [0SMD_R_GRAY]' +'Rated Metric: Green [0SMD_R_GREE]' + 'Rated Metric: Yellow [0SMD_R_YELL]' + 'Rated Metric: Red [0SMD_R_RED]' ) * 100