HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
The name of the fileset control directory below which
the control files for the fileset are stored within an
exported catalog
NVARCHAR(256)ControlDirectory
A boolean value indicating the fileset requires a
kernel rebuild
bitISKernel
A boolean value indicating whether the fileset can
be relocated during installation
bitISLocatable
A boolean value indicating the host on which the
fileset is configured should be re-booted
bitISReboot
Specifies the location below which relocatable files
are stored (This attribute is only valid for filesets in
NVARCHAR(256)Location
installed software. It differs from the product.directory
attribute only if relocation was specified during
installation.)
A list of values which identify the medium on which
the files for this fileset is found
NVARCHAR(256)MediaSequenceNumber
An enumeration: 0 = Deployable, 1 = Installable, 2
= Executable, 3 = Running
SMALLINTSoftwareElementState
Supplies information on version of POSIX
compatibility and corresponds to the operating
NVARCHAR(64)DataModelRevision
system release that packaged or installed the
software
A single attribute that distinguishes versions of
products (and bundles and filesets) with the same
NVARCHAR(16)InstanceIdentifier
Tag (It is a simple form of the version distinguishing
attributes, valid only within the context of an exported
catalog.)
Date timestamp of day, month, year and time when
the software was installed on the system; stored as
MS since the Epoch
BIGINTInstallDate
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
90 HP SIM database tables