HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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
A string indicating what version of SNMP was
detected (Currently HP Systems Insight Manager only
supports “1.0”)
NCHAR(32)SNMPverStr
Flag indicating if this system supports HTTP-based
management; a value of -1 indicates the system was
INTHTTP
not yet identified; a value of 0 indicates HTTP was
not found on the system a value of 1 indicates that
HTTP was found on the system
Flag indicating if this system supports DMI-based
management; a value of -1 indicates the system was
INTDMI
not yet identified; a value of 0 indicates DMI was
not found on the system; a value of 1 indicates DMI
was found on the system
Always 2.0.NCHAR(32)DMIVerStr
If WBEM is detected on the system, then this is set
to 1; otherwise, it is set to 0
INTWBEM
The version of WBEM that HP SIM found on the
system
NCHAR(32)WBEMverStr
If SSH was detected on the system this is set to 1;
otherwise, it is set to 0
INTSSH
The System ID returned from the SSH requestNCHAR(64)SSHverStr
For future expansion.NCHAR(32)PrimaryAddress
The device key of the system that is used for the WMI
proxy for the system for this record (SIM uses the
BIGINT(20)WMIProxyID
system with same device key as the WMIProxyID for
making WBEM to requests through the WMI Mapper
running on that other system)
DeviceSnmpSettings table
The DeviceSnmpSettings table contains the SNMP settings currently configured for the systems. The
DeviceSnmpSettings fields are defined in the following table.
DescriptionData TypeColumn Name
Associates a system with its collected set of data (this
system information is linked using the DeviceKey from
the devices table)
INT*DeviceKey
The network timeout value in secondsINTnetworkTimeout
The number of retries to be used for SNMP requestsINTnetworkRetries
ICMP ping timeout value in secondsINTicmpTimeout
The number of ICMP ping retries to performINTicmpRetries
Defines if this system uses defaults (Global protocol
settings) for some or all protocols or its individual
INTdefaultProtoMask
settings (This is a bitmask field where the different
bits define what defaults are to be used. The values
are logically ordered together: 1= use the default
SNMP read community, 2 = use the default SNMP
write community, 4 = use the default SNMP timeout,
62 HP SIM database tables