HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
BIGINTsourceLUID
INTportForNode
NodeSnapshot table
DescriptionData TypeColumn Name
Snapshot partly identifies NodeSnapshotBIGINTSnapshotID
Node partly identifies NodeSnapshotBIGINTNodeID
Contains the user-defined tagNVARCHAR(256)Tag
Description of the user-defined tagNVARCHAR(512)Description
Stored as MS since the EpochBIGINTCollectionDateTime
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
Database tables 109