HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
An enumerated integer to indicate the role this
software plays in regards to its associated Device;
SMALLINTClassification
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)
Key file name.; an application-specific invariant
identifier that is consistent between versions of a
NVARCHAR(256)IdentifyInfoValue
SoftwareIdentity (It is consistent across more major
changes to the Software Identity naming structure.
The purpose of the parameter is to allow Software
Identities to be selected by a client that are
compatible with a specific
SoftwareInstallationService. A client uses this
parameter to select candidate Software Identities by
comparing TargetType with the contents of the
SupportedTargetTypes parameter in
SoftwareInstallationServiceCapabilities.)
The TargetOperatingSystem property specifies the
Element operating system environment (The value of
SMALLINTTargetOperatingSystem
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 on which the operating
system runs. 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.)
Installation date of this element in CIM date-time
format
NVARCHAR(256)InstallDate
swd_VersionWeight is of CIM_SoftwareElement; a
field used by Software Status Polling
INTswd_VersionWeight
Not standard; a string that specifies the version of
this item
NVARCHAR(64)dc_OtherVersionInfo
Used for reporting purposesSMALLINTOperationalStatus
A free-form string to provide more information for
the DeviceSW_Purpose property
NVARCHAR(512)ClassificationDescription
The HP Smart Array SAS/SATA Event Notification
Service provides event notification to the Windows
NVARCHAR(256)Description
2000/Windows Server 2003 system event log and
the HP ProLiant Integrated Management Log for
systems using the HP Smart Array SAS/SATA
controller driver.
[C:\Program Files\hp\cissesrv, HPQ:cissesrv.exe]
Software/firmware Key file name
NVARCHAR(256)IdentityInfoValue
[HPQ: SoftwarePath, CIM:SoftwareFamily Software
Family Path
NVARCHAR(256)IdentityInfoType
Firmware CategoryNVARCHAR(256)FirmwareCategory
A field used by reportingNVARCHAR(64)R_Type
A field used by reportingNVARCHAR(256)R_Date
Database tables 45