Show TOC

Monitoring History: Table (Values by Minute) Locate this document in the navigation structure

Query Query: 0SMDKPIT4

 

This query is used in the context of the Monitoring History in the System Monitoring work center. It displays the development over time of the selected performance data as a table.

This query is used in the Web template 0SMD_KPI_T4 (Monitoring History: Table (Values by Minute)).

You can also display the performance data as a graphic with or without threshold values. The following analogous queries exist for this purpose:

The query Monitoring History: Table is initially displayed.If the user drills down to values by minute, this query is displayed as the next step. More information about the different queries that are displayed for the different drill down options is available in the Monitoring History: Table section.

Note Note

For correct usage, this query must be used in the context of the above Web template. Use without this wrapper is not meaningful.

End of the note.

Structure

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Time

0TIME

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Green

'green -> yellow' / 'virtual one'

Yellow

'yellow -> red' / 'virtual one'

Mean value

Key figure (technical name 1KYFNM) = mean value (technical name 0SMDAVG)

Minimum

Key figure (technical name 1KYFNM) = minimum (technical name 0SMD_MIN)

Maximum

Key figure (technical name 1KYFNM) = maximum (technical name 0SMD_MAX)

Number of values

Key figure (technical name 1KYFNM) = number of values (technical name 0SMD_COUN)

Total

Key figure (technical name 1KYFNM) = total (technical name 0SMD_SUM)

Virtual One

Key figure (technical name 1KYFNM) = virtual one (technical name 0CCM_EINS)

green -> yellow

Key figure (technical name 1KYFNM) = green -> yellow (technical name 0CCM_G2Y)

yellow -> red

Key figure (technical name 1KYFNM) = yellow -> red (technical name 0CCM_Y2R)