HP Systems Insight Manager 7.1 Database Tables

DC_ProliantHost table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTProliantHost_LUID
Identifies the system ID for this rowBIGINTNodeID
Identifies the snapshot ID for this rowBIGINTSnapshotID
Equates to CIM_ComputerSystemNVARCHAR(256)dc_SystemCreationClassName
The value of CIM_ComputerSystem.Name where
NodeID is equal.
NVARCHAR(256)dc_SystemName
This object represents the overall status of the server
host system represented by this MIB
NVARCHAR(16)OverallCondition
An array of MIB status structures (Each structure is
made up of 4 octets. The first octet is the MIB
NVARCHAR(512)MIBStatusArray
presence. The second octet is MIB condition. The
third octet is MIB major revision. The fourth octet is
MIB minor revision. These blocks of 4 octets each
are index by the mib identifier just after the HP
enterprise (for example, in 1.3.6.1.232.11 mib, the
index is 11). The 4 octets in the first block (block 0)
are reserved for systems management and serve as
an aggregate of their MIBs.)
The globally unique identifier of this server (If the
operating system cannot determine a unique ID, it
NVARCHAR(64)GUID
defaults the variable to contain all 0's. The
management station can then perform a SET to this
variable to provide the unique ID.)
This item indicates the port used by the HP Insight
Management Agent
INTWebManagementPort
The Automatic Server Recovery (ASR) feature status
(If this object is currently Other (1) or Not Available
NVARCHAR(16)ASRStatus
(2), all set operations fail. Any attempt to set this
object to Other (1) or Not Available (2) by a
management station fails. Setting this object to
Disabled (3) or Enabled (4) disables or enables the
ASR feature.)
The HP System ID; this value indicates the HP system
ID of the system board in this system (This ID replaces
INTSystemID
the product ID used in older machines
(cpqSiProductId). A value of 7Eh for the
cpqSiProductId indicates that the cpqSiSystemId
should be used to identify the HP system. A value of
zero (0) indicates that the system ID function is not
supported on this machine. In this case, the
cpqSiProductId should be used to identify the system.)
The system role; this is a settable free form text field
intended to be assigned by a remote console briefly
describing the system's function
NVARCHAR(64)ServerRole
The system detailed description; this is a settable free
form text field intended to be assigned by a remote
console describing the system function in detail
NVARCHAR(512)ServerRoleDetail
The date and time when the agents were last loadedBIGINTConfigChangeDate
The total time (in minutes) the system has been in full
operation (while the server health supporting software
was running)
BIGINTSystemUptime
56 HP SIM database tables