Availability: Overview 

Technical name: 0CPH_NALL_Q0000

Use

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

When executing the query, you can:

Specify specific days, weeks, or months as the time interval (see Time Interval for Selection), depending on the periods for which data exists in the Business Warehouse.

●     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)
0CCM_ATYP	Aggregation Type (Day, Week, Month...)
0CPH_TSEL	Time Selection
0CCMAVOBJ	Availability: Monitored Components

Definable Characteristics

InfoObject	Description
0TIME	Time
0CALDAY	Calendar Day
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
0CCM_LSN	Landscape Name

Rows

InfoObject	Description of the InfoObject (or Restriction or Calculation Formula)
-

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
-