usm_sm_event

Events sent to assure for analysis are stored in this table. Host and contract service events are also stored in this table.

Column Name Column Datatype Column Null Option Column Comment
ts_sec integer not null  
sla_engine_id integer with null  
app_user varchar(64) with null  
interval integer with null  
value float with null  
time_stamp date with null  
data1 integer with null  
data2 varchar(64) with null  
sla_instance_id integer with null Associated SLA package. Is 0 if this is a service event definition.
contract_id integer with null The associated contract.Is 0 if this is a host service event definition.
host_id integer with null The host being measured. Is 0 if this is a contract service event.
slo_instance_id integer with null The associated slo_instance_id. Is 0 if this is a service event definition
metric_category_id integer with null Unique identity identifying the metric category
recurring_event_oid varchar(20) with null Not used in r11
onetime_event_oid varchar(20) with null Not used in r11
calendar_category_oid varchar(20) with null Not used in r11

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.