HP Systems Insight Manager 7.1 Database Tables

consolidatedNodeAuths table
DescriptionData TypeColumn Name
Used for reporting purposesVARCHAR(32)NodeID
Used for reporting purposesVARCHAR(32)UserId
CRA_TaskResults table
DescriptionData TypeColumn Name
INTDeviceKey
VARCHAR(128)jobID
VARCHAR(128)ComponentName
INTstatus
IMAGEstdOut
TEXTstdErr
Credential table
DescriptionData TypeColumn Name
BIGINTLUID
INTcredType
NVARCHAR(256)encrUserName
NVARCHAR(256)encrPassword
NVARCHAR(512)certificateName
DB_DeviceCpu table
DescriptionData TypeColumn Name
INTDeviceKey
INTCpuIndex
DATETIMEUpdateTime
CHAR(100)CpuName
INTCpuSpeed
DB_DeviceInfo table
The DB_DeviceInfo table contains general system information. Any system that supports SNMP has
information in this table. The DB_DeviceInfo fields are defined in the following table.
DescriptionData TypeColumn Name
INT*DeviceKey
Date and time the database record was last updatedDATETIMEUpdateTime
System description.CHAR (200)Description
52 HP SIM database tables