HP Systems Insight Manager 7.2 Database Tables

CIM_PhysicalPackage table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPhysicalPackage _LUID
System partly identifies CIM_PhysicalPackageBIGINTNodeID
Snapshot partly identifies CIM_PortControllerBIGINTSnapshotID
Used for reporting purposesNVARCHAR(255)ElementName
A label by which the object is knownNVARCHAR(1024)Name
Used for reporting purposesNVARCHAR(256)Tag
Used for reporting purposesNVARCHAR(256)CreationClassName
Used for reporting purposesNVARCHAR(64)Manufacturer
Used for reporting purposesNVARCHAR(256)Model
Used for reporting purposesNVARCHAR(256)PartNumber
CIM_PortController table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPortController_LUID
Node partly identifies CIM_PortControllerBIGINTNodeID
Snapshot partly identifies CIM_PortControllerBIGINTSnapshotID
Used for reporting purposesNVARCHAR(255)ElementName
Used for reporting purposesNVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name with equal
NodeID
NVARCHAR(256)SystemName
Used for reporting purposesNVARCHAR(256)CreationClassName
Used for reporting purposesNVARCHAR(64)DeviceID
Used for reporting purposesSMALLINTProtocolSupported
Used for reporting purposesNVARCHAR(256)R_OperationalStatus
INTINTR_PortCount
Used for reporting purposesINTR_PortUtilized
A field used by reportingNVARCHAR(256)R_Condition
A field used by reportingNVARCHAR(256)R_MaxCapacity
Not standard; The redundancy state of the power
supply
NVARCHAR(512)dc_RedundancyState
Not standard; capacity and or output power of the
power supply in watts
INTdc_CurrentOutputPower
32 HP SIM database tables