HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
VARCHAR(255)productVer
VARCHAR(80)licType
VARCHAR(80)licDate
VARCHAR(80)expirationDate
DATETIMEcollectDate
VARCHAR(255)licStatus
VARCHAR(10)licSRC
deviceMxObjValues table
Abstract
DescriptionData TypeColumn Name
INTdeviceKey
CHAR(128)createdBy
BIGINTcreatedTime
CHAR(128)modifiedBy
BIGINTmodifiedTime
DeviceNames table
The DeviceNames table contains the names for devices as determined by the various protocols
that this device supports. The DeviceNames 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 a system
using the DeviceKey from the devices table)
INT*DeviceKey
The name for this system obtained through SNMPCHAR (60)nameSNMP
The name for this system obtained through a name
service (such as WINS or DNS) or the hosts file
CHAR (60)nameIPX
The name for this system obtained through DMICHAR (60)nameDMI
This is the fully qualified DNS name (if available)CHAR (90)NameFullDNS
This field is no longer an active fieldCHAR (60)nameActiveDisc
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.
Database tables 61