HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Partly identifies CIM_NetworkAdapterBIGINTSnapshotID
Equates to CIM_NetworkAdapterNVARCHAR(256)CreationClassName
Inherited from CIM_LogicalDevice.DeviceID; (an
address or other identifying information to uniquely
name the Logical Device)
NVARCHAR(64)DeviceID
Equates to CIM_ComputerSystemNVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name for this
NodeID
NVARCHAR(256)SystemName
A label by which the object is knownNVARCHAR(256)Name
An array of strings indicating the network addresses
for an adapte; represented by a comma separated
list
NVARCHAR(64)NetworkAddress
Inherited from CIM_LogicalDevice.StatusInfo (The
StatusInfo property indicates whether the Logical
SMALLINTStatusInfo
Device is in an enabled (value = 3), disabled (value
= 4), other (value = 1), or unknown (value = 2) state.
If this property does not apply to the LogicalDevice,
the value 5 (Not Applicable), should be used. If a
Device is Enabled (value=3), it has been powered
up and is configured and operational. The system
might not be functionally active, depending on
whether its Availability (or AdditionalAvailability)
indicates that it is Running/Full Power (value=3) or
Off line (value=8). In an enabled but offline mode,
a system might be performing out-of-band requests,
such as running Diagnostics. If (\"Disabled\")
StatusInfo value=4), a device can only be
\"enabled\" or powered off. In a personal computer
environment, (\"Disabled\") means that the system's
driver is not viable in the stack. In other environments,
a system can be disabled by removing its
configuration file. A disabled device is physically
present in a system and consuming resources but
cannot be communicated with until a load of a driver,
a load of a configuration file, or some other
\"enabling\" activity has occurred.
CIM_LogicalDevice.StatusInfo Enumeration. (1 =
Other, 2 = Unknown, 3 = Enabled, 4 = Disabled, 5
= Not Applicable)
PermanentAddress defines the network address
hardcoded into an adapter ( This hardcoded address
NVARCHAR(64)PermanentAddress
can be changed through firmware upgrade or
software configuration. If so, this field should be
updated when the change is made.
PermanentAddress should be left blank if no
hardcoded address exists for the NetworkAdapter.)
Inherited from CIM_ManagedElement.Caption; a
short textual description (one line string) of the object
NVARCHAR(64)Caption
A count of frames for which reception on a particular
interface fails because of an internal MAC sublayer
INTEthernetAdp_InternalMACRcvErr
receive error (A frame is only counted by an instance
of this object if it is not counted by the corresponding
instance of the FrameTooLong property, the
AlignmentErrors property, or the FCSErrors property.
The precise meaning of the count represented by and
instance of this object is implementation-specific. In
particular, an instance of this object can represent a
Database tables 23