HP Systems Insight Manager - Manual (Page 601)

Description Data Type Column Name
Not standard; a text description of the hardware location,
on complex multi-SBB hardware only, for the memory
element NVARCHAR(256) dc_HWLocation
A field used by reporting SMALLINT R_Slot
Description of the element NVARCHAR(64) Description
Memory bank designator nvarchar(64) BankLabel
Location identifiers for memory on boards nvarchar(255) MemLoc_LocationIdentifiers
CIM_PhysicalPackage table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT PhysicalPackage _LUID
System partly identifies CIM_PhysicalPackage BIGINT NodeID
Snapshot partly identifies CIM_PortController BIGINT SnapshotID
Used for reporting purposes NVARCHAR(255) ElementName
A label by which the object is known NVARCHAR(1024) Name
Used for reporting purposes NVARCHAR(256) Tag
Used for reporting purposes NVARCHAR(256) CreationClassName
Used for reporting purposes NVARCHAR(64) Manufacturer
Used for reporting purposes NVARCHAR(256) Model
Used for reporting purposes NVARCHAR(256) PartNumber
CIM_PortController table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT PortController_LUID
Node partly identifies CIM_PortController BIGINT NodeID
Snapshot partly identifies CIM_PortController BIGINT SnapshotID
Used for reporting purposes NVARCHAR(255) ElementName
Used for reporting purposes NVARCHAR(256) SystemCreationClassName
The value of CIM_ComputerSystem.Name with equal
NodeID NVARCHAR(256) SystemName
Used for reporting purposes NVARCHAR(256) CreationClassName
Used for reporting purposes NVARCHAR(64) DeviceID
Used for reporting purposes SMALLINT ProtocolSupported
Used for reporting purposes NVARCHAR(256) R_OperationalStatus
INT INT R_PortCount
Used for reporting purposes INT R_PortUtilized
A field used by reporting NVARCHAR(256) R_Condition
A field used by reporting NVARCHAR(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 INT dc_CurrentOutputPower
Database tables 601