Show TOC

E2E Reporting: Database Utilization - Overview Locate this document in the navigation structure

Query Query: 0E2EREP_ALLSYS_DBUSAGE

 

This query is used in interactive reporting in the Technical Monitoring work center. It displays the utilization of the storage for the selected databases. The query is displayed in the following interactive report:

  • Start of the navigation path Overview Next navigation step Capacity Next navigation step DB Storage End of the navigation path

The query is used in the Web Template 0E2EREP_ALLSYS_DBLOAD (Interactive Reports: Database Utilization Overview).

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

= DB_KPI_usedspace_pfcl [DB_KPI_usedspace_pfcl]

= DB_KPI_dbsize_pfcl [DB_KPI_dbsize_pfcl]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

System ID

0SMD_LSID

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Used Storage [MB]

Key Figure [1KYFNM] = Mean Value [0SMDAVG]

Metric Type [0SMD_METY] = DB_KPI_usedspace_pfcl [DB_KPI_usedspace_pfcl

Free Storage [MB]

'Available Storage (MB)' - 'Used Storage (MB)'

Total Storage [MB]

Key Figure [1KYFNM] = Mean Value [0SMDAVG]

Metric Type [0SMD_METY] = DB_KPI_dbsize_pfcl [DB_KPI_dbsize_pfcl

Service Level in %

'Limit 1 [0CCM_SLL1]' / 'Virtual One' [0CCM_EINS]

110 - 'Service Level in %'