HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
A software pattern matching string describing valid
release members of the uname structure as defined
NVARCHAR(256)OperatingSystemRelease
by POSIX.1 (2), section 4.4.1; used for determining
compatibility
A software pattern matching string describing valid
version members of the uname structure as defined
NVARCHAR(64)OperatingSystemVersion
by POSIX.1 (2), section 4.4.1; used for determining
compatibility
A Boolean value indicating whether this software
object is a patch
bit)ISPatch
Location of source from where software was installedNVARCHAR(128)InstallSource
Supplies information on version of POSIX
compatibility and corresponds to the operating
NVARCHAR(8)DataModelRevision
system release that packaged or installed the
software
Date timestamp of day, month, year and time when
the software was installed on the system; stored as
MS since the Epoch
BIGINTInstallDate
HPUX_VolumeGroup table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTVolumeGroup_LUID
Node partly identifies HPUX_VolumeGroupBIGINTNodeID
Snapshot partly identifies HPUX_VolumeGroupBIGINTSnapshotID
Inherited from CIM_DiskGroup.CollectionID; the
identification of the Collection object
NVARCHAR(64)CollectionID
Name of Volume Group in the SystemNVARCHAR(256)Name
Access Permission of Volume Group in the System;
can be one of the following (Read-Only; Read-Write)
NVARCHAR(64)AccessPermission
Availability status of Volume Group in the System;
can be one of the following values (Available;
Unavailable)
NVARCHAR(32)Status
The size of the fundamental physical extent size in
bytes
INTPhysicalExtentSize
Capacity of whole Volume Group in number of
Physical Extent
INTCapacity
Allocated space in the volume group in number of
Physical Extent
INTAllocated
Number of free Physical Extents in the volume groupINTFreeSpace
Max number of definable physical volume in the
volume group
INTMaxNumberOfPVs
Number of max allocatable Physical Extent from
physical volume
INTNumberOfDefinedPVs
Number of current defined physical volume in the
volume proup
INTNumberOfActivePVs
Max number of definable logical volume in the
volume group
INTMaxNumberOfLVs
98 HP SIM database tables