HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
SystemCreationClassName partly identifies
CIM_Sensor (If the sensor is owned by a chassis,
NVARCHAR(256)SystemCreationClassName
then this field equates to CIM_Chassis; otherwise it
is set to CIM_ComputerSystem.)
Equates to CIM_Sensor.Name or
CIM_ComputerSystem.Name where NodeID is equal
NVARCHAR(256)SystemName
Name partly identifies CIM_Sensor; a label by which
the object is known
NVARCHAR(256)Name
Inherited from CIM_ManagedSystemElement.Status;
a string indicating the current status of the object
NVARCHAR(10)Status
The current state indicated by the Sensor (This is
always one of the Possible States property.)
NVARCHAR(128)CurrentState
Possible States enumerates the string outputs of the
Sensor (For example, a switch sensor can output the
NVARCHAR(512)PossibleStates
states On or Off. Another implementation of the
Switch can output the states Open and Close.
Another example is a NumericSensor supporting
thresholds. This Sensor can report the states like
Normal, Upper Fatal, Lower non-critical and so on.
A Numeric Sensor that does not publish readings
and threshold but stores this data internally can still
report its states.)
The current air temperature at the exhaust of the
power supply in degrees Celsius
INTCurrentReading
The current air temperature at the intake of the power
supply in degrees Celsius
INTdc_OtherCurrentReading
Code for the units used by the readings (pull from
CIM_NumericSensor)
INTBaseUnit
Type of sensor: ValueMap { "0", "1", "2", "3", "4",
"5", "6", "7", "8", "9", "10", "11", "12" }, Values
SMALLINTSensorType
{ "Unknown", "Other", "Temperature", "Voltage",
"Current", "Tachometer", "Counter", "Switch",
"Lock", "Humidity", "Smoke Detection", "Presence",
"Air Flow" }
CIM_SoftwareElement table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTSoftwareElement_LUID
Node partly identifies CIM_SoftwareElementBIGINTNodeID
Snapshot partly identifies CIM_SoftwareElementBIGINTSnapshotID
SoftwareElementID partly identifies
CIM_SoftwareElement (This is an identifier for
NVARCHAR(256)SoftwareElementID
theSoftware Element and is designed to be used in
conjunction with other keys to create a unique
representation of the element.)
SoftwareElementState partly identifies
CIM_SoftwareElement (The SoftwareElementState is
SMALLINTSoftwareElementState
defined in this model to identify various states of a
SoftwareElement life cycle. A SoftwareElement in the
deployable state describes the details necessary to
successfully distribute it and the details (checks and
42 HP SIM database tables