HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Integer code for port type if Ethernet: ValueMap {"0",
"1", "50", "51", "52", "53", 16000..65535"},
SMALLINTEthernetPort_PortType
Values {"Unknown", "Other", "10BaseT",
"10-100BaseT", "100BaseT", "1000BaseT",
"Vendor Reserved"}
Max data size of Ethernet packetsINTEthernetPort_MaxDataSize
VARCHAR(512)IPv6Address
CIM_NetworkPipeComposition table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTAntecendent
Used for reporting purposesBIGINTDependent
CIM_NetworkPort table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTNetworkPort_LUID
Partly identifies CIM_NetworkPortBIGINTNodeID
Partly identifies CIM_NetworkPortBIGINTSnapshotID
Used for reporting purposesNVARCHAR(255)ElementName
A label by which the object is knownNVARCHAR(1024)Name
Used for reporting purposesNVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name with equal
NodeID
NVARCHAR(256)SystemName
Used for reporting purposesNVARCHAR(256)CreationClassName
Used for reporting purposesBIGINTDeviceID
Used for reporting purposesBIGINTSpeed
Used for reporting purposesBIGINTMaxSpeed
Used for reporting purposesSmallIntUsageRestriction
Used for reporting purposesSMALLINTPortType
Used for reporting purposesNVARCHAR(255)OtherPortType
Used for reporting purposesSMALLINTLinkTechnology
Used for reporting purposesNVARCHAR(255)OtherLinkTechnology
Used for reporting purposesNVARCHAR(64)PermanentAddress
Used for reporting purposesSMALLINTPortNumber
Used for reporting purposesNVARCHAR(256)R_OperationalStatus
Used for reporting purposesNVARCHAR(256)R_ParentName
Used for reporting purposesNVARCHAR(256)R_PortType
Database tables 25