HP SIM V5.1 User Guide (356920-009, January 2007)

NodeTypesEnum table
DescriptionData TypeColumn 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.)
INTenumOrd
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
DescriptionData TypeColumn Name
The enumeration identifier for this entry (This can be used
when linking in the deviceSubTypesEnum view.)
INTenumOrd
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.
DescriptionData TypeColumn Name
Unique identifier for this notice instanceINT*NoticeId
• 1=In Progress
• 2=Not Cleared (active)
• 5=Cleared
INTState
Index into the noticeType tableINTNoticeType
1 = Normal, 2 = Warning, 3 = Minor, 4 = Major, 5 =
Critical, 100 = Informational
INTNoticeSeverity
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
bigintLastModifed
If this notice is related to some job, this is the job ID for that
job
char(128)JobID
RESERVEDbigintTimestamp
User names to which an event is assignedVARCHAR(255)AssignedTo
User input comments for one or more eventsVARCHAR(1000)Comments
Database tables 639