HP Systems Insight Manager 7.1 Database Tables

HP_Node table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTHPNode _LUID
Node partly identifies HP_NodeBIGINTNodeID
Snapshot partly identifies HP_NodeBIGINTSnapshotID
A label by which the object is knownNVARCHAR(256)Name
Describes the name for this member in the generic
HP cluster (The inherited Name value must be fully
NVARCHAR(256)Membername
qualified and unique within the enterprise, while the
MemberName value can be an abbreviated version
unique within the cluster.)
An integer value uniquely identifying this cluster
member in the generic HP Cluster; assigned when
INTMemberID
the system is first added to the cluster and remains
unchanged until the system is removed from the
cluster (when this instance is deleted) (If the member
is re-added later to the cluster, a new instance is
created, with a different MemberID value.)
HP_NParCabinet table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTNParCabinet _LUID
Node partly identifies HP_NParCellBIGINTNodeID
Snapshot partly identifies HP_NParCellBIGINTSnapshotID
Values are: Unknown(0), Other(1), 8-cell full height
cabinet(2), 4-cell full height cabinet(3), 4-cell
INTCabinetType
half-height cabinet(4), 2-cell cabinet(5), I/O
expansion cabinet(6). Examples of these cabinet
types: 8-cell full height cabinet (SD-32000), 4-cell
full-height cabinet (SD-16000), 4-cell half-height
cabinet (rp8620), 2-cell cabinet (rx7620)
Display string containing the cabinet number, for
example cab0
NVARCHAR(256)Label
Number of service processors in this cabinetNVARCHAR(256)ServiceProcessorCount
Array of long display names for the location of
service processors in this cabinet (On cabinets where
NVARCHAR(1024)ServiceProcessorLocation
the service processor is location on a core I/O card,
it will include a specification of which card, for
example cab0, coreio0)
Array of status of any service processors in this
cabinet, in the same order as
NVARCHAR(256)ServiceProcessorStatus
ServiceProcessorLocation; values are: Unknown(0),
Other(1), Active(2), Backup(3)
HP_NParCell table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTNParCell_LUID
Node partly identifies HP_NParCellBIGINTNodeID
Database tables 69