HP Systems Insight Manager 7.2 Database Tables

deviceProperties table
Abstract
DescriptionData TypeColumn Name
The deviceKey associates a system with its collected
set of data (system information is linked to a system
using the DeviceKey from the devices table)
INTDeviceKey
CHAR(64)PropertyName
NVARCHAR(255)propertyValue
DeviceProtocolInfo table
The Device Protocol Information 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 a system
using the DeviceKey from the devices table)
INTDeviceKey
Flag indicating if this system is addressable through
TCP/IP
INTIPAddressable
Flag indicating if this system is addressable through
IPX
INTIPXAddressable
Flag indicating if this system, supports SNMP-based
management; a value of -1 indicates the system was
INTSNMP
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
62 HP SIM database tables