HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
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
HPUX_Product table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTProduct_LUID
Node partly identifies HPUX_ProductBIGINTNodeID
Snapshot partly identifies HPUX_ProductBIGINTSnapshotID
Inherited from CIM_Product.IdentifyingNumber;
product identification such as a serial number on
NVARCHAR(256)IdentifyingNumber
software, a die number on a hardware chip, or a
project number
Inherited from CIM_Product.Name; commonly used
Product name
NVARCHAR(256)Name
Inherited from CIM_Product.Version; a vendor-defined
string describing the revision of the product
NVARCHAR(64)Version
Inherited from CIM_Product.Vendor; the name of the
product supplier or entity selling the product (the
manufacturer, reseller, or OEM)
NVARCHAR(256)Vendor
A vendor-defined string used to distinguish variations
of a product (It is used for presentation purposes and
NVARCHAR(64)Architecture
for resolving software specifications. If a product with
the same value of the revision and Vendor Tag
attributes has different versions of software for
different target architectures or any other variation
(such as supported locale), then the value of the
architecture attribute is different for each version. No
additional semantics are assumed for its value.)
Used for resolving software specifications for installed
software (A specific product location refers to all
NVARCHAR(256)Location
filesets of that product that are installed at that
location. This is the path beneath which the
relocatable files of that product are stored.)
Specified by a user when installing software and
used for identifying a product (or set of product
versions) using a logical name
NVARCHAR(64)QualifierID
96 HP SIM database tables