HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
CHAR(128)modifiedBy
BIGINTmodifiedTime
DeviceNames table
The DeviceNames table contains the names for devices as determined by the various protocols
that this device supports. The DeviceNames fields are defined in the following table.
DescriptionData TypeColumn Name
The deviceKey associates a system with its collected
set of data (system information is linked to a system
using the DeviceKey from the devices table)
INT*DeviceKey
The name for this system obtained through SNMPCHAR (60)nameSNMP
The name for this system obtained through a name
service (such as WINS or DNS) or the hosts file
CHAR (60)nameIPX
The name for this system obtained through DMICHAR (60)nameDMI
This is the fully qualified DNS name (if available)CHAR (90)NameFullDNS
This field is no longer an active fieldCHAR (60)nameActiveDisc
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.
deviceProperties table
Abstract
DescriptionData TypeColumn Name
The deviceKey associates a system with its collected
set of data (system information is linked to a system
using the DeviceKey from the devices table)
INTDeviceKey
CHAR(64)PropertyName
NVARCHAR(255)propertyValue
DeviceProtocolInfo table
The Device Protocol Information fields are defined in the following table.
DescriptionData TypeColumn Name
The deviceKey associates a system with its collected
set of data (system information is linked to a system
using the DeviceKey from the devices table)
INTDeviceKey
Flag indicating if this system is addressable through
TCP/IP
INTIPAddressable
Flag indicating if this system is addressable through
IPX
INTIPXAddressable
Flag indicating if this system, supports SNMP-based
management; a value of -1 indicates the system was
INTSNMP
Database tables 61