Show TOC

IT Performance Reports: Availability Locate this document in the navigation structure

Query Query: 0SMDRSAVAILABILITY

 

This query is used in the context of IT Performance Reporting in the System Monitoring work center. The query shows the availability of different instance types of a system (ABAP, Java, TREX, and liveCache).

More information about using this query in the context of IT Performance Reporting is available in the SAP Solution Manager documentation under Reports About Availability.

This query is used in the Web template 0SMD_RS_SYSAVAILABILITY (IT Performance Reports: System Availability).

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

Cal. Year/Month

0CALMONTH

Cal Year/Week

0CALWEEK

Calendar Day

0CALDAY

Time

0TIME

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

System ID

0SMD_LSID

ABAP Availability [%]

0SMD_METY

0SMD_OBNA = 'InstanceAsTask'

JAVA Availability [%]

0SMD_METY

0SMD_OBNA = 'Java InstanceAsTask'

TREX Availability [%]

0SMD_METY

0SMD_OBNA = 'TREX InstanceAsTask'

liveCache Availability [%]

0SMD_METY

0SMD_METY = 'DB_KPI_availability_pfcl_LVC'

Total Availability

MIN ( MIN ( MIN ( 'ABAP Availability [%]' , 'JAVA Availability [%]' ) , 'TREX Availability [%]' ) , 'liveCache Availability [%]' )