HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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.
db_ThirdPartyLink table
DescriptionData TypeColumn Name
NCHAR(255)category
NCHAR(255)linkName
NCHAR(255)url
Database tables 53