HP Systems Insight Manager 7.1 Database Tables

hpmxJob table
DescriptionData TypeColumn Name
VARCHAR(267)JobID
VARCHAR(32)TaskID
VARCHAR(128)ExecuteAsUser
VARCHAR(128)TaskRunBy
VARCHAR(255ToolName
VARCHAR(32)ToolType
INTStateValue
SMALLINTRunNow
BIGINTStartTime
BIGINTEndTime
TEXTExceptionText
TEXTExceptionClass
INTTargetCount
TEXTCommandLine
TEXTFileCopySources
TEXTFileCopyDestinations
SMALLINTOutputToDB
hpmxMDBeanTool table
DescriptionData TypeColumn Name
BIGINTLUID
VARCHAR(1000)MDBeanName
VARCHAR(1000)QueueName
hpmxMgmtAgent table
DescriptionData TypeColumn Name
BIGINTLUID
VARCHAR(64)MaoType
INTPortNumber
VARCHAR(60)IPAddress
VARCHAR(64)Protocol
BIGINTNextMAOLUID
78 HP SIM database tables