HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Additional collection status informationNVARCHAR(512)DetailedInformation
Binary status information. Zero indicates no errorSMALLINTReturnCode
Status of the snapshot for the system; used by
different reports
NVARCHAR(256)Status
Currently unused, reservedINTDataAvailable
Currently unused, reserved for collection filter IDBIGINTFilterID
nodeTypesEnum table
DescriptionData TypeColumn Name
The enumeration identifier for this entry (this can be
used when linking in the deviceTypesEnum view. This
INTenumOrd
should also match the productType value in the
devices table)
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
CHAR(64)enumLabel
guaranteed to be unique across any installation. This
can be linked to the devices tables productSubType
field)
noticeDetails table
DescriptionData TypeColumn Name
INTjobNoticeId
DATETIMEtimeStamp
INTstatus
CHAR(64)resourceId
CHAR(256)details
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 instanceINTNoticeId
1=In Progress
2=Not Cleared (active)
INTState
Database tables 109