HP Systems Insight Manager 5.3 Technical Reference Guide

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 systemCHAR (256)Name
Globally Unique Identifier, a unique key used to identify
this system on the network in the event that it changes its
network address (This requires that a system support
retrieval of this value in order for it to be stored here.)
VARCHAR (128)GUID
The date and time that the system was discovered
represented as the number of milliseconds since 1970 UTC
BIGINTDiscovered
The product type for this item (See the nodeTypesEnum
table, which is best viewed using the deviceSubTypesEnum
view, for additional information.)
INTProductType
A string representation of the product type (See the
nodeTypesEnum table, which is best viewed using the
deviceTypesEnum view, for additional information.)
CHAR(32)ProductTypeStr
The subtype, if any (See the NodeSubTypesEnum table,
which is best viewed using the deviceSubTypesEnum view,
for additional mapping information)
CHAR(32)ProductSubType
Product name (such as ProLiant 1500)NVARCHAR (100)ProductName
Indicates the overall status of the system (0 = Unknown, 1
= Normal, 2 = Warning, 3 = Minor, 4 = Major, 5 =
Critical, 10 = No Status (occurs for new systems or on
startup before polling))
INTOverallStatus
Indicates whether product type, name, or both are locked
so that discovery cannot change them
▲ 0 = Nothing is locked.
INTLockFlags
RESERVED (The last time some system information was
updated, in the database, not just in this table.)
BIGINTTimestamp
The full DNS name of the systemVARCHAR(25)FullDNSName
The HP SIM uniquely assigned identifier for this systemCHAR(32)MxGUID
NVARCHAR(256)DiscoveredName
If the system was found by an SMI-S agent, this will be
equal to the name field of the top-level
CIM_ComputerSystem that represents the system.
NVARCHAR(256)DurableName
NVARCHAR(256)WWName
BIGINT (20)NodeLUID
Used to uniquely identify the systemVARCHAR(256)UniqueIdentifier
DeviceProtocolInfo table
The Device Protocol Information fields are defined in the following table.
DescriptionData TypeColumn Name
The DeviceKey associates this table with the system in the
devices table.
INTDeviceKey
Flag indicating if this system is addressable through TCP/IPINTIPAddressable
Database tables 697