HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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
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
DirSrvGroupCritDomain table
DescriptionData TypeColumn Name
INTDeviceKey
CHAR(255)WindowsDomain
Database tables 65