HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Authentication PassPhraseNVARCHAR(256)encrAuthPassphrase
Privacy protocolTINYINTprivProtocol
Privacy PassphraseNVARCHAR(256)encrPrivPassphrase
DB_DeviceCpu table
DescriptionData TypeColumn Name
INTDeviceKey
INTCpuIndex
DATETIMEUpdateTime
CHAR(100)CpuName
INTCpuSpeed
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
Database tables 53