HP Systems Insight Manager 5.3 Technical Reference Guide

DescriptionData TypeColumn Name
The system role; this is a settable free form text field
intended to be assigned by a remote console briefly
describing the system's function
NVARCHAR(64)ServerRole
The system detailed description; this is a settable free form
text field intended to be assigned by a remote console
describing the system function in detail
NVARCHAR(512)ServerRoleDetail
The date and time when the agents were last loadedBIGINTConfigChangeDate
The total time (in minutes) the system has been in full
operation (while the server health supporting software was
running)
BIGINTSystemUptime
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
696 Reference information