HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
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
Snapshot partly identifies HP_NParCellBIGINTSnapshotID
The ID of the slot the NPar Cell resides inINTSlotID
Total memory (MB) installed in the cellBIGINTTotalMemoryInstalled
Maximum CPU countINTMaxCPUCount
The maximum number of processors supported on
this cell, accounting for both the number of processor
INTMaxCPUCount
module slots and the maximum number of processors
per module supported by this platform (The value
might not reflect the maximum number of processors
in this cell given the number of processor per module
actually installed. The maximum number of processors
per module supported by this system can be
computed by dividing this value by
CPUModuleSlotCount.)
The actual number of processors on this cellSMALLINTCPUCount
The clock speed in megahertz of the processors on
the cell
INTCPUSpeed
Displayable firmware revision stringNVARCHAR(256)FirmwareRevision
Array, indexed by DIMM slot number, indicating
whether the slot contains a DIMM (Note: This
NVARCHAR(256)DIMMSlotPopulated
property might not be available when the cell is
powered off.)
Array, indexed by processor slot number; true when
the processor slot is populated (Note that the
NVARCHAR(256)CPUSlotPopulated
processor slot number divided by the
CPUCountPerModule gives the processor module slot
70 HP SIM database tables