HP Systems Insight Manager 7.1 Database Tables

CIM_Rack table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTRack_LUID
Node partly identifies CIM_RackBIGINTNodeID
Snapshot partly identifies CIM_RackBIGINTSnapshotID
CreationClassName partly identifies CIM_Rack;
equates to CIM_Rack
NVARCHAR(256)CreationClassName
Tag partly identifies CIM_Rack; inherited from
CIM_PhysicalElement.Tag; an arbitrary string that
NVARCHAR(256)Tag
uniquely identifies the Physical Element and serves
as the Element key and can contain information such
as asset tag or serial number data
Inherited from CIM_PhysicalElement.SerialNumber;
a manufacturer-allocated number used to identify the
Physical Element
NVARCHAR(64SerialNumber
A label by which the object is knownNVARCHAR(256)Name
CIM_Realizes table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTDependent
Used for reporting purposesBIGINTAntecedent
CIM_Sensor table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTSensor_LUID
Node partly identifies CIM_SensorBIGINTNodeID
Snapshot partly identifies CIM_SensorBIGINTSnapshotID
DeviceID partly identifies CIM_Sensor; inherited from
CIM_LogicalDevice.DeviceID;. an address or other
NVARCHAR(64)DeviceID
identifying information to uniquely name the Logical
Device
CreationClassName partly identifies CIM_Sensor;
Equates to CIM_Sensor
NVARCHAR(256)CreationClassName
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
Database tables 41