HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
device could be running Diagnostics
(AdditionalAvailability value=5, \"In Test\"). See
CIM_PowerSupply.Availabiltiy enumeration.)
Represents the total output power of the PowerSupply
in milliWatts; 0 denotes Unknown units (milliWatts)
INTTotalOutputPower
Additional information that can identify the power
supply
NVARCHAR(256)OtherIdentifyingInfo
A field used by reportingNVARCHAR(256)R_Status
A field used by reportingNVARCHAR(256)R_Condition
A field used by reportingNVARCHAR(256)R_MaxCapacity
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
34 HP SIM database tables