HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn 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
CIM_PowerSupply table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPowerSupply_LUID
Node partly identifies CIM_PowerSupplyBIGINTNodeID
Snapshot partly identifies CIM_PowerSupplyBIGINTSnapshotID
CreationClassName partly identifies
CIM_PowerSupply; equates to CIM_PowerSupply
NVARCHAR(256)CreationClassName
DeviceID partly identifies CIM_PowerSupply;
inherited from CIM_LogicalDevice.DeviceID; an
NVARCHAR(64)DeviceID
address or other identifying information to uniquely
name the Logical Device
32 HP SIM database tables