E2E Reporting: System Availability (Details)

Query Query: 0E2EREP_SYSTEMPING_DETAIL

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

ABAP Systems Availability System Availability
Java Systems Availability System Availability

The query is used in the Web Template 0E2EREP_SYSTEMPING_DETAIL (Interactive Reports: System Availability - Detailed View).

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
	Calendar Day	`0CALDAY`	—
	Time (hh)	`0SMD_TIHH`	—

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'
	Rated Always Fulfilled		TRUNC( ( MAX( 'Rated Availability in %' , 'Availability in %' ) * 100 ) ) / 100
	Rated Availability in %		Key Figure [1KYFNM] = Mean Value [0SMDAVG] Metric Type [0SMD_METY] = Rated_Availability_SysPercent_JAVA [Rated_Availability_SysPercent_JAVA] Metric Type[0SMD_METY] = Rated_Availability_SysPercent_ABAP [Rated_Availability_SysPercent_ABAP]
	Rounded Availability		TRUNC( ( 'Availability in %' * 100 ) ) / 100
	Availability in %		Key Figure [1KYFNM] = Mean Value [0SMDAVG] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_J2EE [LogClass_Availability_SysPercent_J2EE] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_ABAP [LogClass_Availability_SysPercent_ABAP]
	Proportion of Reported Values		MIN( 100 , ( 'Time Period [s] (LogClass)' / 'Slot Duration' * 100 ) )
	Time Period [s] (LogClass)		Key Figure [1KYFNM] = Time Period [s][0SMD_PERI] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_J2EE [LogClass_Availability_SysPercent_J2EE] Metric Type [0SMD_METY] = LogClass_Availability_SysPercent_ABAP [LogClass_Availability_SysPercent_ABAP]
	Slot Duration		Key Figure [1KYFNM] = Slot Duration [0SMD_SDUR] Metric Type [0SMD_METY] = Rated_Availability_SysPercent_JAVA [Rated_Availability_SysPercent_JAVA] Metric Type[0SMD_METY] = Rated_Availability_SysPercent_ABAP [Rated_Availability_SysPercent_ABAP]