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

Dedicated_values table
DescriptionData TypeColumn Name
Used to uniquely identify this rowBIGINTDedicatedId
Used for reporting purposesSMALLINTDedicatedValue
Used for reporting purposesINTDedicatedPos
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.
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.
Device Extended Attributes database table
The Device Extended Attributes fields are defined in the following table.
DescriptionData TypeColumn Name
The value in minutes a system will be disabled starting with
the time marked by snoozeStartTime
INTsnoozeTimeMin
The initial timestamp from when a system was placed in a
disabled state
LongsnoozeStartTimeMs
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.
DescriptionData TypeColumn Name
The DeviceKey associates a system with its collected set of
data (System information is linked to the device table using
the DeviceKey)
INTDeviceKey
The name of the systemVARCHAR (255)Name
618 Reference information