HP SIM V5.1 User Guide (356920-009, January 2007)

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.
OperationalStatus_SVvalues table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTOperationalStatusId
Used for reporting purposesBIGINTOperationalStatusValue
Database tables 637