HP Systems Insight Manager 5.3 Technical Reference Guide

DescriptionData TypeColumn Name
Associates a system with its collected set of data; system
information is linked to the devices table using the DeviceKe
INT*DeviceKey
A unique IPX index for the system used mainly when 2 or
more IPX addresses exist for a system
INT*IpxIndex
IPX address for this systemCHAR (25)*IPXAddress
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
OperationalStatus_SVvalues table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTOperationalStatusId
Used for reporting purposessmallintOperationalStatusValue
PhysicalPackage_Product table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTPartComponent
Used for reporting purposesBIGINTGroupComponent
SCSIProtoCont_SCSIProtoEnd table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTAvailableSAP
Used for reporting purposesBIGINTMangedElement
SCSIProtocolCont_SoftwareId table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTSystem
Used for reporting purposesBIGINTInstalledSoftware
SCSIProtoEnd_SCSIProtoEnd table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTDependent
Used for reporting purposesBIGINTAntecedent
NetworkAddresses_values table
DescriptionData TypeColumn Name
Uniquely identifies this rowBIGINTNetworkAddressesId
Used for reporting purposesNVARCHAR(64)NetworkAddressesValue
Used for reporting purposesINTNetworkAddressesPos
716 Reference information