HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
A vendor-defined string used to distinguish variations
of a product; used for presentation purposes and for
NVARCHAR(64)Architecture
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 shall be different for each
version. No additional semantics are assumed for
its value.)
A software pattern matching string describing valid
machine members of the uname structure as defined
NVARCHAR(64)MachineType
by POSIX.1 (2), section 4.4.1 (It is used for
determining compatibility.)
A software pattern matching string describing valid
sysname members of the uname structure as defined
NVARCHAR(64)OperatingSystemName
by POSIX.1 (2), section 4.4.1 (It is used for
determining compatibility.)
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 (It is 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)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).
Database tables 91