E2E Reporting: System Availability - Overview

Query Query: 0E2EREP_ALLSYS_SYSTEMPING

This query is used in interactive reporting in the Technical Monitoring work center. It displays the availability for the selected systems. The query is displayed in the following interactive report:

Overview Availability System Availability

The query is used in the Web Template 0E2EREP_ALLSYS_SYSTEMPING (Interactive Reports: System Availability Overview).

Note Note

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

End of the note.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
	Type of Key Figure	`0SMD_METY`	= LogClass_Availability_SysPercent_ABAP [LogClass_Availability_SysPercent_ABAP] = LogClass_Availability_SysPercent_J2EE [LogClass_Availability_SysPercent_J2EE] = Rated_Availability_SysPercent_ABAP [Rated_Availability_SysPercent_ABAP] = Rated_Availability_SysPercent_JAVA [Rated_Availability_SysPercent_JAVA]

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
	System ID	`0SMD_LSID`	—
	Instance Type	`0SMD_SITY`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
	Available		'Available (%)' / MIN( 1, CEIL( 'Available (%)' )
	Not Available Due to Planned Downtime		'Not Available Due to Planned Downtime (%)' / MIN( 1, CEIL( 'Not Available Due to Planned Downtime (%)' )
	No Availability Measurements		'No Availability Measurements (%)' / MIN( 1, CEIL( 'No Availability Measurements (%)' )
	Not Available (Unplanned)		'Not Available (Unplanned) (%)' / MIN( 1, CEIL( 'Not Available (Unplanned) (%)' )
	Available (%)		'Rounded Availability' * 'Proportion of Reported Values' / 100
	Not Available Due to Planned Downtime (%)		( 'Rated Always Fulfilled' - 'Rounded Availability' ) * 'Proportion of Reported Values' / 100
	No Availability Measurements (%)		100 - 'Proportion of Reported Values'
	Not Available (Unplanned) (%)		100 - 'Available (%)' - 'Not Available Due to Planned Downtime (%)' - 'No Availability Measurements (%)'
	Rounded Availability		TRUNC( ( 'Available' * 100 ) ) / 100
	Available		Key Figure [1KYFNM] = Mean Value [0SMDAVG] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_ABAP [LogClass_Availability_SysPercent_ABAP] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_J2EE [LogClass_Availability_SysPercent_J2EE]
	Proportion of Reported Values		MIN( 100 , ( 'Time Period [s] (LogClass)' / 'Interval Duration in Seconds [0SMD_F_SEC]' * 100 ) )
	Rated Always Fulfilled		TRUNC( ( MAX( 'Rated Availability in %' , 'Available' ) * 100 ) ) / 100
	Rated Availability in %		Key Figure [1KYFNM] = Mean Value [0SMDAVG] Metric Type [0SMD_METY] = RatedClass_Availability_SysPercent_ABAP [RatedClass_Availability_SysPercent_ABAP] Metric Type [0SMD_METY] = RatedClass_Availability_SysPercent_JAVA [RatedClass_Availability_SysPercent_JAVA]
	Normalized Time Period		'Time Period [s] (LogClass)'
	Time Period [s] (LogClass)		Key Figure [1KYFNM] = Time Period [s][0SMD_PERI] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_ABAP [LogClass_Availability_SysPercent_ABAP] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_J2EE [LogClass_Availability_SysPercent_J2EE]