HP Systems Insight Manager 7.1 Database Tables

IPAddress table
The IPAddress table contains the known IP addresses for the devices. The IPAddress 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 device table using
the DeviceKey
INT*DeviceKey
The addresses index for the system, for example, 0
is the first IP address. 1 is the second and and so on
INT*ipindex
TCP/IP address (x.x.x.x)CHAR (16)*IPAddress
A numeric representation of the IP addressbigintIPAddressNumber
The MAC address of the system network card
(without and delimiter, such as “:” or “-“)
CHAR (12)MACaddr
The TCP/IP subnet mask (x.x.x.x)CHAR (16)IPsubnetMask
The interface typeIFTypeIFType
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.
IPProtocolEnd_NetworkPort table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTDependent
Used for reporting purposesBIGINTAntecendent
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.
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.
Database tables 101