HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Inherited from CIM_PhysicalPackage.Width and is
the width of the Physical Package in inches
realWidth
Inherited from CIM_PhysicalPackage.Height and is
the height of the Physical Package in inches
realHeight
Inherited from CIM_PhysicalPackage.Depth and is
the depth of the Physical Package in inches
realDepth
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
NVARCHAR(256)PartNumber
responsible for producing or manufacturing the
Physical Element
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 componentNVARCHAR(256)Manufacturer
An enumeration of CIM_ChassisTypes. (1 = Other,
2 = Unknown, 3 = Desktop, 4 = Low Profile Desktop,
SMALLINTChassisTypes
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)
Additional information about the
CIM_Chassis.ChassisTypes
NVARCHAR(512)TypeDescriptions
Inherited from CIM_PhysicalElement.Version and is
a string indicating the version of the Physical Element
NVARCHAR(64Version
Inherited from
CIM_PhysicalElement.OtherIdentifyingInfo. Captures
NVARCHAR(512)OtherIdentifyingInfo
additional data, beyond that of Tag information, that
could be used to identify a Physical Element (One
example is bar code data associated with an Element
that also has an asset tag. If only bar code data is
available and is uniqueable to be used as an Element
key, this property would be NULL and the bar code
data used as the class key, in the Tag property)
A field used by reportingNVARCHAR(256)R_Model
CIM_ComponentCS table
DescriptionData TypeColumn Name
The ComputerSystem that contains and/or
aggregates other systems
BIGINTGroupComponent
The contained (Sub)ComputerSystemBIGINTPartComponent
Database tables 13