Start of Content Area

Query Availability: Daily Overview  Locate the document in its SAP Library structure

Technical name: 0CPH_NALL_Q0001

Use

Use this query to obtain an overview of the average and minimum availability of systems and instances on a daily basis.

When executing the query, you can:

     Specify a particular daily interval as the period

     Restrict the query to particular systems or instances (see Availability: Monitored Components).

In the query itself, you can break down the availability by the hours of the day, among other things.

Filters

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

0CCM_RES

Time Resolution (Minute, 15 Minutes, Hour, Day)

The filter is set to a time resolution of an hour.

0CCM_ATYP

Aggregation Type (Day, Week, Month...)

The filter is set to the aggregation type Day.

0CCMAVOBJ

Availability: Monitored Components

Definable Characteristics

InfoObject

Description

0TIME

Time

0CCM_GATT

GUID for Attributes of a Monitoring Attribute

0CCM_SHR

Hour Slot that Contains a Measured Value

0CCM_MTEC

Monitoring Attribute (MTE Class)

0CCM_PTMZ

Time Zone

0CCM_ATT

Monitoring Attribute

0CCM_OBJ

Monitoring Object

0CCM_SYS

System Name

0CCM_CTX

Monitoring Context

Rows

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

0CALDAY

Calendar Day

Columns

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

(Function)

Availability as a percentage

Function definition:

= total of measured values / number of measured values

0CPHAMIN

Minimum of the availability

0CCM_SUM

Total of Measured Values

0CCM_CNT

Number of Measured Values

Report-Report Interface

Query

Description

-

 

 

 

 

End of Content Area