HP Systems Insight Manager 7.2 Database Tables

IPXAddress table
The IPXAddress table contains the known IPX addresses for the systems. The IPXAddress fields are
defined in the following table.
DescriptionData TypeColumn Name
Associates a system with its collected set of data;
system information is linked to the devices table using
the DeviceKe
INT*DeviceKey
A unique IPX index for the system used mainly when
2 or more IPX addresses exist for a system
INT*IpxIndex
IPX address for this systemCHAR (25)*IPXAddress
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.
iSCSIConn_TCPProtoEnd table
DescriptionData TypeColumn Name
BIGINTAntecedent
BIGINTDependent
LicenseReportingAlgorithms table
DescriptionData TypeColumn Name
CHAR(255)AlgorithmName
LMCertificateList table
DescriptionData TypeColumn Name
INTdeviceKey
VARCHAR(255)deviceType
VARCHAR(255)deviceIP
VARCHAR(255)deviceSN
NVARCHAR(256)nodeName
VARCHAR(36)licenseKey
VARCHAR(36)licenseKeyVer
NVARCHAR(256)licenseType
VARCHAR(30)licenseTypeCode
VARCHAR(30)certificateDate
VARCHAR(30)certificateVersion
VARCHAR(30)certificateSN
VARCHAR(30)productCode
VARCHAR(30)productVcode
102 HP SIM database tables