HP Systems Insight Manager - Manual (Page 619)

Description Data Type Column 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 BIGINT Discovered
The product type for this item (See the nodeTypesEnum
table, which is best viewed using the deviceSubTypesEnum
view, for additional information.) INT ProductType
A string representation of the product type (See the
nodeTypesEnum table, which is best viewed using the
deviceTypesEnum view, for additional information.) VARCHAR(32) ProductTypeStr
The subtype, if any (See the NodeSubTypesEnum table,
which is best viewed using the deviceSubTypesEnum view,
for additional mapping information) VARCHAR(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)) INT OverallStatus
Indicates whether product type, name, or both are locked
so that discovery cannot change them
▲ 0 = Nothing is locked.
INT LockFlags
RESERVED (The last time some system information was
updated, in the database, not just in this table.) BIGINT Timestamp
The full DNS name of the system VARCHAR(90) FullDNSName
The HP SIM uniquely assigned identifier for this system VARCHAR(32) MxGUID
NVARCHAR(32) 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(32) DurableName
NVARCHAR(32) WWName
INT NodeLUID
Used to uniquely identify the system VARCHAR(32) UniqueIdentifier
DeviceProtocolInfo table
The Device Protocol Information fields are defined in the following table.
Description Data Type Column Name
The DeviceKey associates this table with the system in the
devices table. INT DeviceKey
Flag indicating if this system is addressable through TCP/IP INT IPAddressable
Flag indicating if this system is addressable through IPX INT IPXAddressable
Flag indicating if this system, supports SNMP-based
management; a value of -1 indicates the system was not
identified yet; a value of 0 indicates SNMP was not found
on the system; a value of 1 to 5 indicates that SNMP was
found on the system INT SNMP
A string indicating what version of SNMP was detected
(Currently HP Systems Insight Manager only supports “1.0”) NVARCHAR(32) SNMPverStr
Database tables 619