HP Systems Insight Manager 7.1 Database Tables

ManualsBrandsHP ManualsSoftwareHP Systems Insight Manager 4.x Windows Software

DescriptionData TypeColumn Name

Version partly identifies CIM_SoftwareElement;

Software Version should be in the form

NVARCHAR(64)Version

<Major>.<Minor>.<Revision> or

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

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

DescriptionData TypeColumn Name

LUID uniquely defining this table rowBIGINTSoftwareIdentity_LUID

Used to partially identify CIM_SoftwareIdentityBIGINTNodeID

Used to partially identify CIM_SoftwareIdentityBIGINTSnapShotID

InstanceID opaquely and uniquely identifies an

instance of this class. To ensure uniqueness within

NVARCHAR(255)InstanceID

the NameSpace, the value of InstanceID SHOULD

Database tables 43