HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
5=Cleared
Index into the noticeType tableINTNoticeType
1 = Normal
2 = Warning
INTNoticeSeverity
3 = Minor
4 = Major
5 = Critical
100 = Informational
ReservedINTNoticePriority
Index into the devices tableINTDeviceKey
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
BIGINTLastModified
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
INTassociatedAlertId
VARCHAR(32)thirdPartySource
VARCHAR(32)thirdPartyID
VARCHAR(32)thirdPartyState
noticeType table
DescriptionData TypeColumn Name
Unique system assigned identifierVARCHAR(32)GUID
System assigned identifierINTnoticeType
A unique String Identification for the eventCHAR(255)typeIdStr
CHAR(100)category
Internal handler for the display of the eventCHAR(255)dispHandler
Internal handler for event reception, usually blankCHAR(255)rxHandler
A default severity to use for the eventINTdefaultSeverity
Used when the CRSM is installedINTserviceEnable
Used when the CRSM is installedINTproviderID
110 HP SIM database tables