HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Equates to CIM_ComputerSystemNVARCHAR(256)SystemCreationClassName
Equates to the value of CIM_ComputerSystem.Name
where NodeID is equal
NVARCHAR(256)SystemName
Equates to HPUX_NTPServiceNVARCHAR(256)CreationClassName
Inherited from CIM_ManagedSystemElement.Name;
the Name property defines the label by which the
object is known
NVARCHAR(256)Name
Inherited from CIM_ManagedElement.Caption; a
short textual description of the object
NVARCHAR(64)Caption
This attribute is specified by host name that appears
in the file /etc/hosts, or it is an IP Address in dot
NVARCHAR(512)ServerAddress
notation format (Multiple servers are specified as
comma delimited names.)
Inherited from CIM_ManagedElement.Description;
provides a textual description of the object
NVARCHAR(512)Description
HPUX_PhysicalVolume table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPhysicalVolume_LUID
Node partly identifies HPUX_PhysicalVolumeBIGINTNodeID
Partly identifies HPUX_PhysicalVolumeBIGINTSnapshotID
Name of Physical Volume in the SystemNVARCHAR(256)Name
Inherited from CIM_LogicalDevice.DeviceID; an
address or other identifying information to uniquely
NVARCHAR(64)DeviceID
name the LogicalDevice (Might return the name of
the physical volume. For example,
/dev/dsk/c0t0d0.)
Can return alternate physical volume path name (For
example, /dev/rdsk/c0t0d0; returns the same
as DeviceID replacing "dsk" for "rdsk")
NVARCHAR(256)AlternatePVName
Availability status of Physical Volume. Returns
(Available; Unavailable).
NVARCHAR(32)Status
Size in bytes; calculated by multiplying
HPUX_PhysicalVolume.BlockSize by the
HPUX_PhysicalVolume.NumberOfBlocks
BIGINTPhysicalExtentSize
Capacity of the whole Physical Volume in number of
Physical Extent
BIGINTCapacity
Size of the allocated Physical Volume in number of
Physical Extent
INTAllocated
Size of the free Physical Volume space in number of
Physical Extent
INTFree
Counter of Staled Physical Extent in the Physical
Volume
INTNumberStaledPEs
Database tables 95