HP Systems Insight Manager 5.3 Technical Reference Guide

DB_DeviceInfo table
The DB_DeviceInfo table contains general system information. Any system that supports SNMP has information
in this table. The DB_DeviceInfo fields are defined in the following table.
DescriptionData TypeColumn Name
INT*DeviceKey
Date and time the database record was last updatedDATETIMEUpdateTime
System description.CHAR (200)Description
Physical location (must be filled in at the system)CHAR (200)Location
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.
DescriptionData TypeColumn 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 updatedDATETIMEUpdateTime
Total amount of system memoryINTTotalMemory
System ROM versionCHAR (80)ROMVersion
System serial numberCHAR (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 versionCHAR (100)OSVersion
Vendor name of the operating systemCHAR(64)OSVendor
If present, the name of the cluster to which this system
belongs
CHAR (100)ClusterName
The description of the host operating systemCHAR(100)OSDescription
System trust state for HP web enabled agentsIntTrustStatus
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
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTEnslosure_LUID
694 Reference information