HP Systems Insight Manager 7.1 Database Tables

operationalStatusCD_values table
DescriptionData TypeColumn Name
BIGINTOperationalStatusId
SMALLINTOperationalStatusValue
INTOperationalStatusPos
operationalStatusMAD_values table
DescriptionData TypeColumn Name
BIGINTOperationalStatusId
SMALLINTOperationalStatusValue
INTOperationalStatusPos
otherIdentifyingInfo_SVvalues table
DescriptionData TypeColumn Name
BIGINTOtherIdentifyingInfoId
NVARCHAR(256)OtherIdentifyingInfoValue
INTOtherIdentifyingInfoPos
PhysicalPackage_Product table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTPartComponent
Used for reporting purposesBIGINTGroupComponent
PlugInInfo table
DescriptionData TypeColumn Name
BIGINTPlugInInfoID
NVARCHAR(256)Name
NVARCHAR(1024)PackageName
INTClassIdentifier
NVARCHAR(255)ClassIdString
PortController_SoftwareIdent table
DescriptionData TypeColumn Name
BIGINTSystem
BIGINTInstalledSoftware
112 HP SIM database tables