User`s guide

SPECTRUM Data Types
Events
Data Structure of SQL Tables Data Export User’s Guide
C-4 Version 5.0rev1
Events
Description: Event data collected during the specified time period
Columns: ts The time stamp, a date field
lh The landscape handle, a 4-byte integer
mh The model handle, a 4-byte integer
eventype The event type, a 4-byte integer
severity The event severity, a 4-byte integer
alarm _num The alarm number, a 4-byte integer, nulls
allowed
condition The event condition code, a 2 byte integer,
nulls allowed
eventmsg The event message, a database-dependent
varying character string, as follows:
Oracle = 512 characters;
Ingres = 256 characters
Microsoft SQL Server = 255 characters
Sybase = 255 characters
Indexed by: ts + lh + mh
Table C-3. Format for Events
Time
Stamp
(ts)
Landscape
Handle
(lh)
Model
Handle
(mh)
Event
Type
(eventype)
Severity
(sever-
ity)
Alarm#
(alarm_num)
Condition
(condition)
Event Message
(eventmsg)
04/15/
1998
10:07:03
4194304 10485760 67330 0 2 6 Wed 15 April 1998 -
10:07:03 - Alarm
number 41 cleared
for device Demo
CNB-25 of type
Bdg_CSI_ CNB25.
(event 00010702)
04/15/
1998
10:07:03
4194304 10485760 66305 0 0 Wed 15 April 1998 -
10:07:03 - Device
Demo CNB-25 of
type
Bdg_CSI_CNB25
has been contacted.
(event 00010301)
date 4-byte int. 4-byte int. 4-byte int. 4-byte int. 4-byte int. 2-byte int. database-dependent
varchar
ÑÑÑÑÑ INDEX ÑÑÑÑÑ