HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
OS9, 46 = MACH Kernel, 47 = Inferno, 48 = QNX,
49 = EPOC, 50 = IxWorks, 51 = VxWorks, 52 =
MiNT, 53 = BeOS, 54 = HP MPE, 55 = NextStep,
56 = PalmPilot, 57 = Rhapsody, 58 = Windows
2000, 59 = Dedicated, 60 = OS/390, 61 = VSE,
62 = TPF, 63 = Windows Me, 64 = Caldera Open
UNIX, 65 = OpendBSD, 66 = Not Applicable)
A value set by the implementation to be the time that
the catalog information for this object was first
written.; stored as MS since the Epoch
BIGINTCreateTime
Inherited from CIM_ManagedElement.Description;
this property provides a textual descrition of the
object
NVARCHAR(512)Description
A value set by the implementation to be the time that
the catalog information for this objectwas last written;
stored as MS since the Epoch
BIGINTModificationTime
The sum of the sizes in bytes of all files and control
files contained within the software object (For objects
NVARCHAR(32)Size
other than filesets, the value is computed dynamically
as required.)
Inherited from CIM_ManagedElement.Caption; a
short textual description of the object
NVARCHAR(128)Caption
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
90 HP SIM database tables