HP Systems Insight Manager - Manual (Page 637)

IPAddress table
The IPAddress table contains the known IP addresses for the devices. The IPAddress fields are defined in the
following table.
Description Data Type Column 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 address bigint IPAddressNumber
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 type IFType IFType
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
Description Data Type Column Name
Used for reporting purposes BIGINT Dependent
Used for reporting purposes BIGINT Antecendent
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.
Description Data Type Column 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 system CHAR (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.
OperationalStatus_SVvalues table
Description Data Type Column Name
Used for reporting purposes BIGINT OperationalStatusId
Used for reporting purposes BIGINT OperationalStatusValue
Database tables 637