HP Systems Insight Manager 5.3 Technical Reference Guide

DescriptionData TypeColumn Name
Date/time notice was generated or received represented
as the number of milliseconds since 1970 UTC
bigintGenerated
Date/time notice was cleared represented as the number
of milliseconds since 1970 UTC
bigintCleared
RESERVEDbigintCompleted
RESERVEDbigintLastChecked
Date/time notice was cleared represented as the number
of milliseconds since 1970 UTC
bigintLastModifed
If this notice is related to some job, this is the job ID for that
job
varchar(128)JobID
RESERVEDbigintTimestamp
User names to which an event is assignedNVARCHAR(255)AssignedTo
User input comments for one or more eventsNVARCHAR(1000)Comments
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
NoticeType table
The NoticeType table defines all of the event types that can be processed. The NoticeType fields are defined
in the following table.
DescriptionData TypeColumn Name
System assigned identifier.INT*NoticeType
Unique system assigned identifierVarChar(32)GUID
A unique String Identification for the eventCHAR (255)TypeIdStr
Internal handler for the display of the eventCHAR (255)dispHandler
Internal handler for event reception, usually blank.Char(255)rxHandler
A default severity to use for the eventIntdefaultSeverity
The internal privilege level a user must have to view the
event details
IntPrivilege
Used when the CRSM is installedINTServiceEnable
Used when the CRSM is installedINTServiceEnable
Used when the CRSM is installedINTProviderID
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
OperationalStatus_CSvalues table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTOperationalStatusId
Used for reporting purposesSMALLINTOperationalStatusValue
Used for reporting purposesINTOperationalStatusPos
718 Reference information