si_kpi_prop

This table holds the trending snapshot data for Unicenter Service Intelligence

Column Name Column Datatype Column Null Option Column Comment
uuid byte(16) not null Primary key for si_rec_kpi
sequence integer with null The sequenc that the KPI statements are executed in a multi-query KPI
name nvarchar(100) with null Display name of the metric that the results set is being generated for.
group nvarchar(100) with null The sequence grouping for executing nested KPI queries.
type nvarchar(16) with null This field indicates the type of data (string, uuid, integer, date/time stamp, duration or Top X) returned in the result set.
query long nvarchar with null The Query that is to be executed to derrive the KPI metric from.
local integer with null The where clause used to generate the result set for the metric specified in si_kpi_hist
phase nvarchar(16) with null Source that the data was received from

Product Name: Unicenter Service Intelligence

Table Type: Table


Copyright © 2006 CA. All rights reserved.