HP Systems Insight Manager - Manual (Page 585)

CIM_ActiveConnection table
Description Data Type Column Name
A ServiceAccessPoint that is configured to communicate
and/or is actively communicating with the Dependent SAP.
In a unidirectional connection, this is the SAP that is
transmitting. BIGINT Antecedent
A second SeriveAccessPoint that an communicate with the
Antecedent SAP. In a unidirectional connection, this is the
SAP that is receiving the communication. BIGINT Dependent
CIM_Chassis table
Description Data Type Column Name
LUID uniquely defines this row BIGINT Chassis_LUID
Partly identifies CIM_Chassis BIGINT NodeID
Partly identifies CIM_Chassis BIGINT SnapshotID
Partly identifies CIM_Chassis and equates to CIM_Chassis NVARCHAR(256) CreationClassName
An arbitrary string that uniquely identifies the Physical
Element, serves as the Element key and can contain
information such as asset tag or serial number data NVARCHAR(256) Tag
The product ID string of the enclosure and is empty if the
enclosure does not report the productID string NVARCHAR(64) dc_ProductID
If the chassis is part of a rack, then this attribute is
CIM_Rack; otherwise, it is CIM_ComputerSystem NVARCHAR(256) dc_SystemCreationClassName
If the chassis is part of a rack, then this attribute is the value
of CIM_Rack.Name; otherwise, it is the value of the owning
CIM_ComputerSystem.Name NVARCHAR(256) dc_SystemName
A label by which the object is known NVARCHAR(256) Name
A user-friendly name for the object NVARCHAR(256) ElementName
Inherited from CIM_PhysicalPackage.Width and is the width
of the Physical Package in inches real Width
Inherited from CIM_PhysicalPackage.Height and is the
height of the Physical Package in inches real Height
Inherited from CIM_PhysicalPackage.Depth and is the depth
of the Physical Package in inches real Depth
Inherited from CIM_PhysicalElement.SerialNumber and is
a manufacturer-allocated number used to identify the
Physical Element NVARCHAR(64) SerialNumber
Inherited from CIM_PhysicalElement.PartNumber and is the
part number assigned by the organization responsible for
producing or manufacturing the Physical Element NVARCHAR(256) PartNumber
Inherited from CIM_PhysicalElement.SKU and is the stock
keeping unit number for this Physical Element NVARCHAR(64) SKU
Inherited from CIM_PhysicalElement.Model and is the name
by which the Physical Element is generally known NVARCHAR(64) Model
Name of the manufacturer of the component NVARCHAR(256) Manufacturer
An enumeration of CIM_ChassisTypes. (1 = Other, 2 =
Unknown, 3 = Desktop, 4 = Low Profile Desktop, 5 = Pizza
Box, 6 = Mini Tower, 7 = Tower, 8 = Portable, 9 = Laptop,
10 = Notebook, 11 = Hand Held, 12 = Docking Station,
13 = All in One, 14 = Sub Notebook, 15 = Space Saving,
16 = Lunch Box, 17 = Main System Chassis, 18 =
Expansion Chassis, 19 = SubChassis, 20 = Bus Expansion
Chassis, 21 = Peripheral Chassis, 22 = Storage Chassis,
23 = Rack Mount Chassis, 24 = Sealed-Case PC) SMALLINT ChassisTypes
Database tables 585