HP Systems Insight Manager - Manual (Page 598)

CIM_PhysicalElement table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT PhysicalElement_LUID
Node partly identifies CIM_PhysicalElement BIGINT NodeID
Snapshot partly identifies CIM_PhysicalElement BIGINT SnapshotID
CreationClassName partly identifies CIM_PhysicalElement;
equates to CIM_PhyscialElement NVARCHAR(256) CreationClassName
Tag partly identifies CIM_PhysicalElement; an arbitrary
string that uniquely identifies the Physical Element and serves
as the Element's key and can contain information such as
asset tag or serial number data NVARCHAR(256) Tag
Inherited from CIM_ManagedElement.Caption; a short
textual description (one line string) of the object NVARCHAR(64) Caption
Inherited from CIM_ManagedElement.Description; a textual
description of an object NVARCHAR(512) Description
The label by which this object is known NVARCHAR(256) Name
Inherited from CIM_ManagedSystemElement.InstallDate; a
datetime value indicating when the object was installed; a
lack of a value does not indicate that the object is not
installed BIGINT InstallDateTime
Inherited from CIM_ManagedSystemElement.Status; a string
indicating the current status of the object NVARCHAR(10) Status
Date this physical element was manufactured BIGINT ManufactureDate
The name of the organization responsible for producing
the Physical Element (This can be the entity from which the
element is purchased, but this is not necessarily true. The
latter information is contained in the Vendor property of
CIM_Product.) NVARCHAR(256) Manufacturer
The name by which the Physical Element is generally known NVARCHAR(64) Model
Captures 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. Note that if only bar code data is
available and is unique or able 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.) NVARCHAR(512) OtherIdentifyingInfo
The part number assigned by the organization responsible
for producing or manufacturing the Physical Element NVARCHAR(256) PartNumber
Boolean value indicating that the Physical Element is
powered on (true), or is currently off (false) bit PoweredOn
A manufacturer-allocated number used to identify the
Physical Element NVARCHAR(64) SerialNumber
The stock keeping unit number for this Physical Element NVARCHAR(64) SKU
A string indicating the version of the Physical Element NVARCHAR(64) Version
The Number property indicates the physical slot number,
which can be used as an index into a system slot table,
whether that slot is physically occupied SMALLINT Slot_Number
Not standard; a string describing the location of the
physical element NVARCHAR(64) dc_Location
Not standard; a string describing the condition of the
physical element such as OK, Degraded, or Failed NVARCHAR(64) dc_Condition
Not standard; a firmware revision associated with the
physical element NVARCHAR(64) dc_FirmwareRevision
Not standard; a text description of the hardware location,
on complex multi-SBB hardware only, for the element NVARCHAR(256) dc_HWLocation
598 Reference information