HP Systems Insight Manager - Manual (Page 639)

NodeTypesEnum table
Description Data Type Column Name
The enumeration identifier for this entry (This can be used
when linking in the deviceTypesEnum view. This should also
match the productType value in the devices table.) INT enumOrd
Unique (non displayable) string used for identifying a
product type (This is the only value guaranteed to be unique
across any installation.) char(64) enumLabel
NodeSubTypesEnum table
Description Data Type Column Name
The enumeration identifier for this entry (This can be used
when linking in the deviceSubTypesEnum view.) INT enumOrd
This is a unique (non displayable) string used for identifying
a product subtype (This is the only value guaranteed to be
unique across any installation. This can be linked to the
devices tables productSubType field.) char(64) enumLabel
Notices table
The Notices table contains all the events received or generated, such as Discovered Device events, SNMP
traps and so on. The Notices fields are defined in the following table.
Description Data Type Column Name
Unique identifier for this notice instance INT *NoticeId
• 1=In Progress
• 2=Not Cleared (active)
• 5=Cleared INT State
Index into the noticeType table INT NoticeType
1 = Normal, 2 = Warning, 3 = Minor, 4 = Major, 5 =
Critical, 100 = Informational INT NoticeSeverity
RESERVED INT NoticePriority
Index into the devices table INT DeviceKey
Date/time notice was generated or received represented
as the number of milliseconds since 1970 UTC bigint Generated
Date/time notice was cleared represented as the number
of milliseconds since 1970 UTC bigint Cleared
RESERVED bigint Completed
RESERVED bigint LastChecked
Date/time notice was cleared represented as the number
of milliseconds since 1970 UTC bigint LastModifed
If this notice is related to some job, this is the job ID for that
job char(128) JobID
RESERVED bigint Timestamp
User names to which an event is assigned VARCHAR(255) AssignedTo
User input comments for one or more events VARCHAR(1000) Comments
Database tables 639