Monitoring History: Table (Daily Values)

Query Query: 0SMDKPIT2

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_T2 (Monitoring History: Table (Daily Values)).

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 daily values, 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
	Calendar Day	`0CALDAY`	0CALDAY = 'Day Interval (technical name `0I_DAYIN`)

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`)
	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`)
	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`)