E2E Reporting: Host Availability - Overview 
Query: 0E2EREP_ALLSYS_HOSTPING
This query is used in interactive reporting in the Technical Monitoring work center. It displays the availability for the selected hosts. The query is displayed in the following interactive report:
Overview 
Availability Host Availability 
The query is used in the Web Template 0E2EREP_ALLSYS_HOSTPING (Interactive Reports: Host Availability Overview).
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.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Type of Key Figure |
0SMD_METY |
= LogClass_Host_Availability [LogClass_Host_Availability] |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Physical Host |
0SMD_SPHH |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Available |
'Available (%)' / MIN( 1, CEIL( 'Available (%)' ) |
|
| No Availability Measurements |
'No Availability Measurements (%)' / MIN( 1, CEIL( 'No Availability Measurements (%)' ) |
|
| Not Available |
'Not Available (%)' / MIN( 1, CEIL( 'Not Available (%)' ) |
|
| Available (%) |
'Rounded Availability' * 'Proportion of Reported Values' / 100 |
|
| No Availability Measurements (%) |
100 - 'Proportion of Reported Values' |
|
| Not Available (%) |
100 - 'Available (%)' - 'No Availability Measurements (%)' |
|
| Rounded Availability |
TRUNC( ( 'Availability [0SMDAVG]' * 100 ) ) / 100 |
|
| Proportion of Reported Values |
TRUNC( ( MIN( 100 , ( 'Normalized Time Period' / 'Interval Duration in Seconds [0SMD_F_SEC]' * 100 ) ) * 100 ) ) / 100 |
|
| Normalized Time Period |
'Time Period [s] [0SMD_PERI] |