HP Systems Insight Manager 7.2 Database Tables

ComputerSys_SoftwareIdent table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTSystem
Used for reporting purposesBIGINTInstalledSoftware
ComputerSys_StorageVol table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTGroupComponent
Used for reporting purposesBIGINTPartComponent
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
SNMPv3 engine IDNVARCHAR(256)engineId
Context engine IDNVARCHAR(256)contextEngineId
Context nameNVARCHAR(256)contextName
Security nameNVARCHAR(256)encrSecurityName
Security levelTINYINTsecurityLevel
Authentication protocolTINYINTauthProtocol
52 HP SIM database tables