HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
CHAR(200)UrlInfo
CHAR(100)UrlBuilder
CHAR(100)UrlStatusSource
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
VARCHAR (128)GUID
it changes its network address (This requires that a
system support retrieval of this value in order for it
to be stored here.)
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
INTProductType
the deviceSubTypesEnum view, for additional
information.)
A string representation of the product type (See the
nodeTypesEnum table, which is best viewed using
CHAR(32)ProductTypeStr
the deviceTypesEnum view, for additional
information.)
The subtype, if any (See the NodeSubTypesEnum
table, which is best viewed using the
CHAR(32)ProductSubType
deviceSubTypesEnum view, for additional mapping
information)
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
INTOverallStatus
= Major, 5 = Critical, 10 = No Status (occurs for
new systems or on startup before polling))
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
system
CHAR(32)MxGUID
NVARCHAR(256)DiscoveredName
Database tables 65