Previous Topic: usp_ical_event_template TableNext Topic: usp_kpi_data Table


usp_kpi Table

Contains KPIs of Stored Query type, SQL type, and System type.

Field

Data Type

Reference

Remarks

name

string

 

Defines the name of the KPI.

type

integer

 

Indicates where the KPI data is retrieved from, such as the crsq database table, BPVirtdb, or daemons in the BOP system.

status

integer

 

Indicates the on/off state of the KPI.

process_type

integer

 

Indicates the daemon process where the KPI data resides.

metric_type

integer

 

Indicates the type of metric the KPI produces (for example, count or sum).

stored_query_id

string

 

Provides a REF to the id attribute in the Crsq table. It is a SREL to REL_ATTR of object crsq, and contains the value of the code of a row in the crsq object.

user_context

string

 

Provides a UUID REF to the ca_contact table.

sql_query

string

 

Defines a SQL query.

description

string

 

Describes the measurement goal for the KPI.

refresh_time

integer

 

The time interval at which the KPI data is updated.

sys_name

string

 

The internal KPI name for sys type KPIs.

curr_kpi_time_stamp

integer

 

The last collection time of this KPI.

version_number

integer

 

Indicate the version of this KPI.

tenant

string

 

Provides a UUID REF to the ca_tenant table.

last_mod_by

string

 

Specifies the foreign key of the ca_contact table (UUID).

last_mod_dt

integer

 

Specifies the date and time of last update (integer value in UNIX ticks).