HP Systems Insight Manager - Manual (Page 616)

Description Data Type Column Name
The contact for this system (must be filled in at the system) CHAR (200) Contact
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
DB_DeviceInfoEx table
The DB_DeviceInfoEx table contains basic information for systems that are running the HP SIM agent or a
standard Desktop Management Interface (DMI) service layer. The DB_DeviceInfoEX fields are defined in the
following table.
Description Data Type Column Name
The DeviceKey associates a system with its collected set of
data; system information is linked to the device table using
the DeviceKey INT *DeviceKey
Date and time the database record was last updated DATETIME UpdateTime
Total amount of system memory INT TotalMemory
System ROM version CHAR (80) ROMVersion
System serial number CHAR (80) SerialNumber
System asset tag (must be filled in at the system) CHAR (100) AssetTag
Operating system name. Note: This is not the same
OSName from the tool definitions files; this is the
OSNameStr value from mxnode
CHAR (100) OSName
The OSType identifier that is used for tool definitions
OSName field; this is a value like WINNT, HPUX, or LINUX CHAR(100) OSType
Operating system version CHAR (100) OSVersion
Vendor name of the operating system CHAR(64) OSVendor
If present, the name of the cluster to which this system
belongs CHAR (100) ClusterName
The description of the host operating system CHAR(100) OSDescription
System trust state for HP web enabled agents Int TrustStatus
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
DC_Enclosure table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT Enslosure_LUID
Node partly identifies dc_Enclosure BIGINT NodeID
Snapshot partly identifies dc_Enclosure BIGINT SnapshotID
Tag partly identifies dc_Enclosure and is an arbitrary string
that uniquely identifies the enclosure and serves as the
Element key NVARCHAR(256) Tag
The unique address of the enclosure within the rack INT dc_Address
The maximum number of server blades the enclosure can
contain INT dc_EnclosureMaxNumBladesX
616 Reference information