Monitoring History: Table

Query Query: 0SMDKPIT1

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_T1 (Monitoring History: Table).

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

From the monitoring history display, you can drill down directly to a higher time resolution for the data. The following queries are called when you do so, depending on which time resolution you have selected:

Query	Resolution
0SMDKPIT2	Daily Average Values as a Table
0SMDKPIT3	Hourly Average Values as a Table
0SMDKPIT4	Average Values by Minute as a Table

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