HP Systems Insight Manager - Manual (Page 609)

Description Data Type Column Name
Used for reporting purposes NVARCHAR(1024) Name
Used for reporting purposes NVARCHAR(256) SystemCreationClassname
The value of CIM_ComputerSystem.Name with equal
NodeID NVARCHAR(256) SystemName
Used for reporting purposes NVARCHAR(256) CreationClassName
Used for reporting purposes NVARCHAR(256) ProtocolIFType
CIM_Rack table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT Rack_LUID
Node partly identifies CIM_Rack BIGINT NodeID
Snapshot partly identifies CIM_Rack BIGINT SnapshotID
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 uniquely
identifies the Physical Element and serves as the Element
key and can contain information such as asset tag or serial
number data NVARCHAR(256) Tag
Inherited from CIM_PhysicalElement.SerialNumber; a
manufacturer-allocated number used to identify the Physical
Element NVARCHAR(64 SerialNumber
A label by which the object is known NVARCHAR(256) Name
CIM_Realizes table
Description Data Type Column Name
Used for reporting purposes BIGINT Dependent
Used for reporting purposes BIGINT Antecedent
CIM_Sensor table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT Sensor_LUID
Node partly identifies CIM_Sensor BIGINT NodeID
Snapshot partly identifies CIM_Sensor BIGINT SnapshotID
DeviceID partly identifies CIM_Sensor; inherited from
CIM_LogicalDevice.DeviceID;. an address or other
identifying information to uniquely name the Logical Device NVARCHAR(64) DeviceID
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, then this field equates to
CIM_Chassis; otherwise it is set to CIM_ComputerSystem.) NVARCHAR(256) SystemCreationClassName
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
Database tables 609