HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
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 knownNVARCHAR(256)Name
Inherited from
CIM_ManagedSystemElement.InstallDate; a datetime
BIGINTInstallDateTime
value indicating when the object was installed; a
lack of a value does not indicate that the object is
not installed
Inherited from CIM_ManagedSystemElement.Status;
a string indicating the current status of the object
NVARCHAR(10)Status
Date this physical element was manufacturedBIGINTManufactureDate
The name of the organization responsible for
producing the Physical Element (This can be the entity
NVARCHAR(256)Manufacturer
from which the element is purchased, but this is not
necessarily true. The latter information is contained
in the Vendor property of CIM_Product.)
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
NVARCHAR(512)OtherIdentifyingInfo
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.)
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)
bitPoweredOn
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 ElementNVARCHAR(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
SMALLINTSlot_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
28 HP SIM database tables