HP Systems Insight Manager - Manual (Page 611)

Description Data Type Column Name
TargetOperatingSystem partly identifies
CIM_SoftwareElement (The TargetOperatingSystem 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.) SMALLINT TargetOperatingSystem
Inherited from CIM_ManagedSystemElement.InstallDate;
the datetime value indicating when the object was installed BIGINT InstallDate
A field used by reporting NVARCHAR(256) R_Date
A field used by reporting NVARCHAR(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 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) SMALLINT DeviceSW_Purpose
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 INT swd_VersionWeight
Not standard. A string that specifies the version of this item NVARCHAR(64) dc_OtherVersionInfo
A field used by reporting. NVARCHAR(64) R_Type
CIM_SoftwareIdentity table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT SoftwareIdentity_LUID
Used to partially identify CIM_SoftwareIdentity BIGINT NodeID
Used to partially identify CIM_SoftwareIdentity BIGINT SnapShotID
Database tables 611