HP Systems Insight Manager 7.2 Database Tables

INIT_TRACKER table
DescriptionData TypeColumn Name
NUMERICINIT_ID
VARCHAR(255)absoluteFilePath
VARCHAR(255)verDir
VARCHAR(255)dataType
VARCHAR(255)parentDir
VARCHAR(255)fileState
NUMERICfileLastModified
VARCHAR(3000)fileName
VARCHAR(3000)statusMsg
VARCHAR(255)fileExt
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.
Database tables 101