HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Not standard; indicates whether the power supply
is present in the chassis
NVARCHAR(32)dc_PowerSupplyPresent
The status of the power supply (noError (1),
generalFailure (2), bistFailure 32), fanFailure (4),
NVARCHAR(64)dc_PowerSupplyStatus
tempFailure (5), interlockOpen (6), epromFailed (7),
vrefFailed (8), dacFailed (9), ramTestFailed (10),
voltageChannelFailed (11), orringdiodeFailed (12),
brownOut (13), giveupOnStartup (14), nvramInvalid
(15), calibrationTableInvalid (16))
Not standard; the redundancy state of the power
supply
NVARCHAR(32)dc_PowerSupplyState
Not standard; capacity and or output power of the
power supply in watts
INTdc_CurrentOutputInfo
OtherIdentifyingInfo captures additional data,
beyond DeviceID information, that could be used to
identify a LogicalDevice
NVARCHAR(256)OtherIdentifyingInfo
Indication of the type the power supply device
including:
SMALLINTType
"0" = Unknown
"1" = Other
"2" = Compute Cabinet Bulk Power Supply
"3" = Compute Cabinet System Backplane Power
Supply
"4" = Compute Cabinet I/O chassis enclosure Power
Supply
"5" = Compute Cabinet AC Input Line
"6" = I/O Expansion Cabinet Bulk Power Supply
"7" = I/O Expansion Cabinet System Backplane
Power Supply
"8" = I/O Expansion Cabinet I/O chassis enclosure
Power Supply
"9" = I/O Expansion Cabinet AC Input Line
Position is a free-form string indicating the placement
of a PhysicalElement. It can specify slot information
NVARCHAR(64)Location
on a HostingBoard, mounting site in a Cabinet, or
latitude and longitude information, for example, from
a GPS. It is part of the key of the Location object.
Position is a free-form string indicating the placement
of a PhysicalElement. It can specify slot information
NVARCHAR(64)PhysicalPosition
on a HostingBoard, mounting site in a Cabinet, or
latitude and longitude information, for example, from
a GPS. It is part of the key of the Location object.
The Caption value can be one of the following,
depending on the device type:
NVARCHAR(64)Caption
• Compute Cabinet Bulk Power Supply
• Compute Cabinet Backplane Power Supply
• Compute Cabinet I/O Chassis Enclosure Power
Supply
• Compute Cabinet AC Input Line
• I/O Expansion Cabinet Bulk Power Supply
• I/O Expansion Cabinet Backplane Power Supply
34 HP SIM database tables