HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
by POSIX.1 (2)Use t section 4.4.1 (It is used for
determining compatibility.)
Location of source from where software was installedNVARCHAR(128)InstallSource
A Boolean value indicating whether this software
object is a patch
bitISPatch
Denotes a fileset that is not complete, but one that
has been qualified as an update (as opposed to a
bitISSparse
patch) (One outcome of updating through a sparse
fileset is that the catalog information from the old
fileset is merged into the new fileset and the old fileset
is then removed, leaving the system in the same state
as it would be after an update of a full fileset. This
option should be used in conjunction with an ancestor
attribute showing exactly which versions of software
this sparse fileset can update. Filesets that are sparse
are only useful when installed along with those
versions or when those versions are already
installed.)
Only applied to installed patches; characterizes the
current state of an installed patch
NVARCHAR(16)PatchState
Only applicable to installed patches; specifies the
software on which this patch fileset has been applied
NVARCHAR(256)AppliedPatches
Lists what patch superseded this patchNVARCHAR(256)SupercededBy
Used by swinstall during the installation of this patch
fileset to save the patched files if patch_save_files
NVARCHAR(256)SavedFileDirectory
was set to true at that time (When rolling back or
committing this patch, this attribute is used to
determine the directory to access those saved files)
NOTE: WBEM providers is only collected under the Desktop Management Interface (DMI).
HPUX_HFS table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTHFS_LUID
BIGINTNodeID
BIGINTSnapshotID
Inherited from CIM_FileSystem.Name; the inherited
Name serves as key of a FileSystem instance within
a ComputerSystem
NVARCHAR(256)Name
Equates to HPUX_HFSNVARCHAR(256)CreationClassName
Equates to CIM_ComputerSystemNVARCHAR(256)CSCreationClassName
Equates to CIM_ComputerSystem.Name where
NodeID is equal
NVARCHAR(256)CSName
Inherited from CIM_FileSystem.Root; path name or
other information defining the root of the FileSystem
NVARCHAR(256)Root
Inherited from CIM_FileSystem.ReadOnly; indicates
that the FileSystem is designated as read only
bitReadOnly
Database tables 91