HP Systems Insight Manager 7.1 Database Tables

CIM_ActiveConnection table
DescriptionData TypeColumn Name
A ServiceAccessPoint that is configured to
communicate and/or is actively communicating with
BIGINTAntecedent
the Dependent SAP. In a unidirectional connection,
this is the SAP that is transmitting.
A second ServiceAccessPoint that can communicate
with the Antecedent SAP. In a unidirectional
BIGINTDependent
connection, this is the SAP that is receiving the
communication.
CIM_Changer_Device table
DescriptionData TypeColumn Name
BIGINTchangerDevice_LUID
BIGINTNodeID
BIGINTSnapshotID
NVARCHAR(255)ElementName
NVARCHAR(256)SystemCreationClassName
NVARCHAR(256)SystemName
NVARCHAR(256)CreationClassName
NVARCHAR(64)DeviceID
SMALLINTAvailability
NVARCHAR(64)r_FirmwareVersion
CIM_Chassis table
DescriptionData TypeColumn Name
LUID uniquely defines this rowBIGINTChassis_LUID
Partly identifies CIM_ChassisBIGINTNodeID
Partly identifies CIM_ChassisBIGINTSnapshotID
Partly identifies CIM_Chassis and equates to
CIM_Chassis
NVARCHAR(256)CreationClassName
An arbitrary string that uniquely identifies the Physical
Element, serves as the Element key and can contain
information such as asset tag or serial number data
NVARCHAR(256)Tag
The product ID string of the enclosure and is empty
if the enclosure does not report the productID string
NVARCHAR(64)dc_ProductID
If the chassis is part of a rack, then this attribute is
CIM_Rack; otherwise, it is CIM_ComputerSystem
NVARCHAR(256)dc_SystemCreationClassName
If the chassis is part of a rack, then this attribute is
the value of CIM_Rack.Name; otherwise, it is the
value of the owning CIM_ComputerSystem.Name
NVARCHAR(256)dc_SystemName
A label by which the object is knownNVARCHAR(256)Name
A user-friendly name for the objectNVARCHAR(256)ElementName
12 HP SIM database tables