HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
actions) required to move it to the installable state
(for example, the next state). A SoftwareElement in
the installable state describes the details necessary
to successfully install it and the details (checks and
actions) required to create an element in the
executable state (for example, the next state). A
SoftwareElement in the executable state describes
the details necessary to successfully start it and the
details (checks and actions) required to move it to
the running state for example, the next state). A
SoftwareElement in the running state describes the
details necessary to manage the started element.
CIM_SoftwareElement.SoftwareElementState
enumeration 0 = Deployable, 1 = Installable, 2 =
Executable, 3 = Running)
Version partly identifies CIM_SoftwareElement;
Software Version should be in the form
NVARCHAR(64)Version
<Major>.<Minor>.<Revision> or
<Major>.<Minor><letter><revison>
Name partly identifies CIM_SoftwareElement; the
name used to identify this software element
NVARCHAR(256)Name
TargetOperatingSystem partly identifies
CIM_SoftwareElement (The TargetOperatingSystem
SMALLINTTargetOperatingSystem
property specifies the Element operating system
environment. The value of this property does not
ensure that it is binary executable. Two other pieces
of information are needed. First, the version of the
operating system must be specified using the class,
CIM_OSVersionCheck. The second piece of
information is the architecture that the operating
system runs on. This information is verified using
CIM_ArchitectureCheck. The combination of these
constructs clearly identifies the level of operating
system required for a particular SoftwareElement.
See CIM_OperatingSystem.OSType Enumeration.)
Inherited from
CIM_ManagedSystemElement.InstallDate; the
BIGINTInstallDate
datetime value indicating when the object was
installed
A field used by reportingNVARCHAR(256)R_Date
A field used by reportingNVARCHAR(256)R_Status
Inherited from CIM_ManagedElement.Description;
a textual description of an object
NVARCHAR(512)Description
DeviceSoftware_Purpose; an enumerated integer to
indicate the role this software plays in regards to its
SMALLINTDeviceSW_Purpose
associated Device; CIM_DeviceSoftware.Purpose
enumeration (0 = Unknown, 1 = Other, 2 = Driver,
3 = Configuration Software, 4 = Application
Software, 5 = Instrumentation, 6 = Firmware, 7 =
BIOS, 8 = Boot ROM)
A free-form string to provide more information for
the DeviceSW Purpose property
NVARCHAR(512)DeviceSW_PurposeDescription
swd_VersionWeight is of CIM_SoftwareElement; a
field used by Software Version Polling
INTswd_VersionWeight
Database tables 43