HP Systems Insight Manager - Manual (Page 618)

Dedicated_values table
Description Data Type Column Name
Used to uniquely identify this row BIGINT DedicatedId
Used for reporting purposes SMALLINT DedicatedValue
Used for reporting purposes INT DedicatedPos
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
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.
Description Data Type Column 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 SNMP CHAR (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 DMI CHAR (60) nameDMI
This is the fully qualified DNS name (if available) CHAR (90) NameFullDNS
This field is no longer an active field CHAR (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.
Device Extended Attributes database table
The Device Extended Attributes fields are defined in the following table.
Description Data Type Column Name
The value in minutes a system will be disabled starting with
the time marked by snoozeStartTime INT snoozeTimeMin
The initial timestamp from when a system was placed in a
disabled state Long snoozeStartTimeMs
Devices table
The Devices table contains discovered system information. This is the primary table used to define system
related data. The Devices fields are defined in the following table.
Description Data Type Column Name
The DeviceKey associates a system with its collected set of
data (System information is linked to the device table using
the DeviceKey) INT DeviceKey
The name of the system VARCHAR (255) Name
618 Reference information