HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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
number. All processor slots where that value is equal
are in the same processor module.)
True if this cell is connected to an IO chassisBITConnectedToIOChassis
I/O Chassis ID of the chassis to which the cell is
connected (The property is not present if
ConnectedToIOChassis is false.)
INTConnectedIOChasssId
The architecture of the processors on this cell; values
are Unknown(0), Other(1), PA-RISC(2) and
Itanium®-based(3)
SMALLINTCellArchitecture
Status of this component; values are: Unknown(0),
Other(1), Powered Off(2), Powering On(3),
SMALLINTComponentStatus
Inactive(4), Active(5) (A component is powering on
when power has been turned on, but it is still
performing power-on self-tests (POST). A component
is Inactive if it has completed POST, but has not
joined its nPartition. This might be because the
component is not assigned to a nPartition, if it is
assigned to a nPartition and the nPartition is not
active, if the component failed during nPartition boot,
if the component was assigned to an active nPartition
and no reboot or shut down for reconfiguration of
the nPartition has been done, or the component has
been configured to remain inactive when the
nPartition boots. A component is active when it has
joined a nPartition during boot. Note that the status
of the component does not imply anything about the
state of the operating system on the nPartition. The
component will be active, for example, while the
operating system is still in the boot process. The status
70 HP SIM database tables